Re: Better way?

y1799_at_yahoo.com wrote:

> Hi ,
>
> my query does not work bad for the small tables but maybe exists
> something more productive:
> select F1 from A
> where F1 not in (select F1 from B)
>
> Thanks

Not exists might be far more efficient as might the minus Alan has suggesed. Run autotrace and timing and find out.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)