CREATE CURSOR Table1 (Ssn C(11)) CREATE CURSOR Table2 (Social C(11)) SELECT Ssn FROM Table1 ; WHERE Ssn IN (SELECT Social FROM Table2)Is that what you needed to know?
> SELECT * FROM Orders ; >> INTO CURSOR Temp ; >> WHERE OrdID IN (SELECT OrdID FROM OrdItems O1 WHERE item = 'hammer') ; >> AND OrdID IN (SELECT OrdID From OrdItems O2 WHERE item = 'nails')