You seem to be doing it fine as far as I can see, except for "song_id" which should be 
"songs_id" in the query...


Barry Rumsey wrote:

> Hi
> I have three tables set out below:
> xp_artist: artist_id , artist _name
> xp_sings: artist_id , songs_id
> xp_songs: songs_id , song_name , lyrics
> I can not figure out how to query and return the results for a  query like:
> "select song_name FROM xp_artist,xp_sings,xp_songs WHERE xp_artist.artist_id = 
>xp_sings.artist_id AND xp_sings.song_id = xp_songs.songs_id AND artist_name LIKE 

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to