Re: Not Exists-module
Jelmer Wrote:
> And I'm talking about this part:
>
> WHERE id NOT EXISTS (SELECT id FROM categories WHERE title = 'Ajax')
You need IN instead of EXISTS:
WHERE id NOT IN (SELECT id FROM categories WHERE title = 'Ajax')
... EXISTS (SELECT ...) return TRUE or FALSE
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Written By
Posted
Re: Not Exists-module
January 25, 2007 11:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.