Try thi out:* FROM Categories WHERE NOT EXISTS (SELECT Cat_ID FROM Join_Cat WHERE Comp_ID = 1);
gesf New member Jan 29, 2006 #1 Try thi out: Code: * FROM Categories WHERE NOT EXISTS (SELECT Cat_ID FROM Join_Cat WHERE Comp_ID = 1);
Try thi out: Code: * FROM Categories WHERE NOT EXISTS (SELECT Cat_ID FROM Join_Cat WHERE Comp_ID = 1);
Alexej Kubarev New member Jan 29, 2006 #2 Subquery support has been added to version 4.1 and its not working in 4.0
