Re: help on mulit query
| From: | Bogdan Stancescu | Date: | Mon, 07 Jan 2002 00:51:34 +0000 |
| Subject: | Re: help on mulit query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15466@lists.php.net to get a copy of this message | ||
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%'";