Re: A database design challenge!

>If I change the SQL thus:
 

>select cds.*, artists.ar_name, tracks.*, artists.ar_name
> from cds, artists, tracks, artists artists_a1
> where cds.cd_ar_key = ar_ar_key
> and tracks.tr_cd_key = cds.cd_key
> and tracks.tr_ar_key = artists_a1.ar_key

This is exactly how you do it. When you are doing a Join, you can only reference each Set once. In this case you needed to reference it twice. So the artist table is treated as if it is two tables.

Kasu Sista
Links Technology Corp. Received on Mon Jul 17 1995 - 00:00:00 CEST