Posted by Diogenes on 10/11/06 15:54

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

[Back to original message]