[thelist] SQL replace subquery with join

[Bill Moseley]

On Tue, Jan 5, 2010 at 7:56 AM, Jason Handby <jason.handby at corestar.co.uk>wrote:

> Your version using IN looks fine to me, anyway, what's wrong with doing
> it that way?
>

Not really.  I'm using an ORM and not using the subquery would make life
easier.

I think what I wrote was incorrect, though.  Probably should have been:

SELECT cd.*
FROM cd
WHERE NOT EXISTS  (
    SELECT NULL FROM genre g WHERE g.cd = cd.id AND g.name = 'rock'
)

But, I suppose that might depend on how the database optimizes the query.



-- 
Bill Moseley
moseley at hank.org