MySQL 3 Table join question...

[eluser]port22[/eluser]
It changes the query, but just use the join table (artists_cds) as the starting point.

So, you would do a join much like this:

select * from
artists_cds join artists
join catalogue
join format

Which will produce a detailed table of everything. If you want a specific artist, catalogue or format, you can just throw in where clauses as necessary.