Re: missing from one table

gooiditweg_at_sybrandb.verwijderdit.demon.nl says...
> <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,

When might you suggest that the following would be more efficient?

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

Geoff M Received on Mon Oct 04 2004 - 19:08:15 CDT