Weird. I had sent a query and it posted my last post and has not sent my other one...I was not speaking of your query Bobby. Sorry bout that. I was talking about my own.
Ok, this is by adding a albumid to you artisttrack table. Of course you will have multiple id's listed in there, but it is just a list of id's. My naming convention are a little different but you get the picture. SELECT ar.artist_id, ar.name, a.album_id, a.album_name, a.year FROM artists ar INNER JOIN artists_albums_tracks aat ON ar.artist_id = aat.artist_id INNER JOIN albums a ON aat.album_id = a.album_id ----- Original Message ----- From: "Bobby Hartsfield" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, November 06, 2006 7:14 AM Subject: RE: Query Problem > Im not sure which one you mean. The first one I posted DID use inner joins > and the problem was of course returning the same artist multiple times... > (probably the same number of tracks) > > The second should NOT need an inner join from what I see. It should be fine > as is. > > -----Original Message----- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: Monday, November 06, 2006 9:10 AM > To: CF-Talk > Subject: Re: Query Problem > > Actually, you should use a inner join on that, so not to return records you > do not need. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259268 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
