Re: distinct with <>

vegas_girlie wrote:

> hi. the business problem is pretty simple. i need to find out if
> there are any email addresses that exist in table A that do not exist
> in table B. out of the 6500 records in table A there should be only a
> few hundred records that do not exist in Table B.
>
> thanks!

Your three choices are:

NOT EXISTS
NOT IN
SUBTRACT You can find examples of all three of these if you go to: http://www.psoug.org
click on Explain Plan
scroll down and look at examples 1-6.
A little modification of several of these will solve the problem.

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