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:259267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
