Missing from one table

#1

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?

#2

Dale DeRemer wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Missing from one table

comp.databases.oracle comp.databases.oracle

Missing from one table - 10-04-2004 , 03:17 PM

Re: Missing from one table - 10-04-2004 , 05:45 PM