Re: Missing from one table
From: Hans Forbrich <news.hans_at_telus.net>
Date: Mon, 04 Oct 2004 22:45:14 GMT
Message-ID: <_nk8d.24372$N%.2502_at_edtnps84>
Date: Mon, 04 Oct 2004 22:45:14 GMT
Message-ID: <_nk8d.24372$N%.2502_at_edtnps84>
Dale DeRemer wrote:
> We want to make a query where we check table A for employee numbers and
> compare that with table B. We would like to build a list of employees who
> are in table A but not in table B. An ideas on how to build that type of
> query?
Use the SELECT 'MINUS' capability. (SELECT ... MINUS SELECT ...) Received on Tue Oct 05 2004 - 00:45:14 CEST