Re: What does the (+) operator mean in sql queries?

From: Pablo Sanchez <pablo_at_dev.null>
Date: Tue, 16 Apr 2002 09:43:29 -0600
Message-ID: <CEXu8.20$x_3.74842@news.uswest.net>

"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:ulmbo1bkl.fsf_at_rcn.com...
> On Sun, 14 Apr 2002, RubberDucky703_at_hotmail.com wrote:
>
> > How does the outer join work?
>
> CONSIDER:
>
> [ snipped ]

And to add to this excellent example:

Find me data that is _not_ in t2 but is in t1 - in other words, how can I find data that is missing in t2 quickly and efficiently?

SQL> select * from t1,t2 where t1.fld1 = t2.fld1 (+) and t2.fld1 IS NULL; FLD1 FLD1
---------- ----------

         1
         3

--
Pablo Sanchez, High-Performance Database Engineering
mailto:pablo_at_hpdbe.com
Available for short-term and long-term contracts

Received on Tue Apr 16 2002 - 10:43:29 CDT