January 24th, 2000, 04:31 AM
I can read in the manual that these nested queries cannot be made. However there is no example on how to solve my problem w/o nesting:
select * from product where prodId not in (select catProdId from categoryMember)
What I want, obviously, is to show all products not being member of any category.
Thnx for any tips,
January 24th, 2000, 09:05 AM
It is possible to rewrite this subselect as a left join....
from product LEFT JOIN categoryMember
WHERE categoryMember.catProdID IS NULL;