Re: Comlicated SELECT statement. Help appreciated!
Posted by:
Dan Dean
Date: March 14, 2005 04:28PM
Thanks Nick, your example worked wonderfully. I modified a couple of things and the final code is below. Thanks again!
Dan
SELECT dd_album.*, count(dd_asset.asset_album_id) AS album_size
FROM dd_album
LEFT JOIN dd_asset
ON dd_asset.asset_album_id = dd_album.album_id
GROUP BY dd_album.album_label
Subject
Written By
Posted
Re: Comlicated SELECT statement. Help appreciated!
March 14, 2005 04:28PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.