IOW, you can substitute other tables for OrdItems below as long as it includes the key OrdID.

> 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')