IOW, you can substitute other tables for OrdItems below as long as it includes the key OrdID.
> SELECT * FROM Orders ;
> INTOCURSOR Temp ;
> WHERE OrdID IN (SELECT OrdID FROM OrdItems O1 WHEREitem = 'hammer') ;
> AND OrdID IN (SELECT OrdID From OrdItems O2 WHEREitem = 'nails')