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...
Bogdan 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 >'b%'"; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]