Re: join query question

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Thu, 21 Jun 2001 22:09:45 GMT
Message-ID: <3b327035.278896171@news.alt.net>

On 21 Jun 2001 16:34:09 -0500, jmel_at_mailnews.com (mel) wrote:

>
>It depends on a number of factors. A hash anti join may be the best.
>
>You can use
>
>not in
>not exists
>minus
>outer join using nulls
>hash anti-join
>
>
>in order from worse to best most texts list
>
>not in
>minus
>not exists
>outer join using nulls
>hash anti-join

Could you point me to (or give me a simple example) of the two latter cases?

outer join using nulls
hash anti-join

Brian Received on Thu Jun 21 2001 - 17:09:45 CDT