RE: left outer join
- From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 Aug 2004 15:25:22 -0400
Aaaargh! Why do people use that @#$%! ANSI-standard syntax
instead of user friendly "+"!!!! I thought that his query
is something like:
select count(*) from tab1 g1,tab2 g2
where g1.iuid(+) = g2.yypid
and g2.yypid is null;
That's what happens when people decide that they should follow standards!
--
Mladen Gogala
Oracle DBA
email:mladeng@xxxxxxxxx
Ext: 9787
> -----Original Message-----
> From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx]
> Sent: Friday, August 20, 2004 3:21 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: left outer join
>
>
> Mladen,
>
> I think you have left and right outer join confused. The
> left or right = indicates the side of the join that is not deficient.
>
> So, in the example below, tab1 left join tab2 means that tab1
> has all = rows and tab2 may be missing rows.
>
> So, I think his query is valid. He's counting how many rows
> in tab1 are = not in tab2 (where tab2.yyid is null).
>
> -Mark
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
