joining tables

[Stuart Briscar]

Okay. I need to join tables to make this work. Lets see. I have a database the following tables:

TABLE "SONGS"
|songID
|songName
|songArtist
|songRequest

TABLE "STATIONS"
|stationID
|stationName
|stationCity
|stationState
|stationSite

then I have the channel table to join them:

TABLE "CHANNEL"
|songID
|stationID

On my site I will need to list all the stations listed with any given song. Say I need the song Butterfly that was heard on the stations KISS FM, K98, and Star94, how would I get those pulled from the database?

[oodie]

SELECT stationName,stationCity,stationState,stationSite 
FROM STATIONS, SONGS, CHANNEL 
WHERE CHANNEL.songID = SONGS.songID AND
      CHANNEL.stationID = STATIONS.stationID AND
      SONGS.songName = 'Butterfly'

[smorb]

Hey what I always wanted to know, does it make any difference between what "oodie" says and this here using a LEFT JOIN:

SELECT stationName,stationCity,stationState,stationSite 
FROM STATIONS LEFT JOIN SONGS ON STATIONS.stationID = SONGS.songID WHERE SONGS.songName = 'Butterfly';