Re: help with a query
From: Kris Timmerman <74171.1714_at_CompuServe.COM>
Date: 1995/04/27
Message-ID: <3nou25$1rb$1_at_mhafa.production.compuserve.com>#1/1
Date: 1995/04/27
Message-ID: <3nou25$1rb$1_at_mhafa.production.compuserve.com>#1/1
Here is an approach that may or may not be suitable.
select order_no from line_items where item_no = 23
intersect
select order_no from line_items where item_no = 21;
This will return only those orders that are for both hammer and wrench. Received on Thu Apr 27 1995 - 00:00:00 CEST