| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.oracle -> Re: Missing from one table
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 Mon Oct 04 2004 - 17:45:14 CDT
 |
 |