Re: missing from one table

"Dale DeRemer" <dderemer_nospam_at_agmc.org> wrote in news:cjsbi5$2qv$1_at_malgudi.oar.net:

> 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?
>
>

select emp_id from table_a
minus
select emp_id from table_b; Received on Tue Oct 05 2004 - 08:58:37 CDT