SELECT * ; FROM Companies Co JOIN Sales Sa ; ON Co.keyvalue = Sa.keybedra ; WHERE Sa.Price > 0 ; UNION ALL ; SELECT * FROM Companies Comp ; WHERE Comp.KeyValue NOT IN (SELECT Keybedra FROM Sales) ; INTO CURSOR GoodResult