Posted by Diogenes on 10/12/06 17:59

Kudos to the Captain! That works beautifully both on the
command line and in PHP!

Thank you! Thank you! Thank you!

Cheers
Jim

Captain Paralytic wrote:
> Diogenes wrote:
>
>>Captain Paralytic wrote:
>>
>>>Diogenes wrote:
>>>
>>>>SELECT pkey, Name FROM tracks WHERE artist="Rolling Stones"
>>>>AND pkey NOT IN (SELECT Song FROM requests WHERE client="jim")
>>>>
>>>
>>>
>>>It is almost always more efficient to use the LEFT JOIN alternative for
>>>this task
>>>
>>
>>I'm a little naive on SQL. Could you redo the above SELECT
>>statement with your suggested alternative? Then I'll try it
>>in PHP.
>>
>>Cheers
>>Jim
>
>
> Without seeing the scheme and some sample data I can't be sure that
> I've captured all the nuances of what you want, but try:
>
> SELECT pkey, Name FROM tracks
> LEFT JOIN requests ON tracks.pkey = requests.Song AND requests.client =
> "jim"
> WHERE tracks.artist="Rolling Stones" AND requests.Song IS NULL
>

[Back to original message]