Re: missing from one table

On Mon, 4 Oct 2004 16:24:34 -0400, "Dale DeRemer" <dderemer_nospam_at_agmc.org> 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?
>

select ... from a where empid not in (select empid from b)

--
Sybrand Bakker, Senior Oracle DBA