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%'";

Reply via email to