Joining three tables
Posted on 2011-02-23
I need help joining three tables with the JOIN USING syntax. Here is what I have could you please tell me what I'm overlooking?
Select song_id, cd_number, title, comments
From d_play_list_items JOIN d_cds
The tables d_play_list_items & d_track_listings share the song_id column.
The tables d_track_listings & d_cds share the cd_number column.
When I submit this query it tells me that it is missing keyword