Re: distinct with <>

Randy Harris wrote:
> "vegas_girlie" <minnie_valerie_at_hotmail.com> wrote in message
> Without the arguments for NULL, the query says:
>
> Find ALL records in eml and include any matching records in
eml_address.
>
> With the Null argument, it says:
>
> Find all records in eml where there is no matching record in
eml_address.
> (The matchup is NULL on the eml_address side)
>
> This is the technique that I learned to find unmatched records.
Daniel
> Morgan suggests using NOT EXISTS. Perhaps that would be more
efficient? I
> dunno.

search asktom.oracle.com for examples of efficiency, like http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:953229842074

jg

--
@home.com is bogus.
Go Phil!  http://www.ics.uci.edu/~darpagc/live/gallery/index.php