MySQL 3 Table join question...

[eluser]f244[/eluser]
Hi,

Many thanks for your reply, that's a perspective I hadn't considered - too bogged down in thinking about the query to take a step back.

artists_cds - ( id, catid, artid ) ( Where catid = foreign key to catalogue id and artid to artists id )

If I understand you correctly, the table 'artist_cds' would just have the ids of catalogue items and the relevant artist ids? eg. To use the example of catalogue item 1 having two artists and artist 1 having two catalogue items...

artists_cds

id catid artid
1 1 1
2 1 2
3 2 3
4 3 1

Am I understanding this right? If so how does that affect my query above where I'm trying to retrieve all the details for a catalogue item from the database (including multiple artists). I'm starting to get a little confused about my original MySQL query and all the joins now...!

Thanks!