You are da man. Ed! Ed! Ed!

>

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

>
>I'd make sure that OrdItems had indexes on OrdID and Item.