Posted by Captain Paralytic on 10/12/06 08:40

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

• Next in forum: Re: when browser is closed
• Prev in forum: Re: PHP on Sparc Solaris 10 ?
• Thread view: Re: PHP 5 / MySQL 5 subquery problem

[Reply to this message]