MySQL 3 Table join question...

[eluser]port22[/eluser]
Best solution is to change your database design to something similar to the following, making it relational:

catalogue - ( id, title, etc )

artists - ( id, name, etc )

formats - ( id, format, etc ) ( Be wary with this table as it may actually contain data that fits nicely in catalogue )

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