Oracle & ANSI Compliance

[drooganleader]

Does Oracle support the ANSI standard INNER JOIN.<br>

<br>

I haerd from someone that it did not, I'm quite surpirised. If thats true what is the Oracle equivalent?<br>

<br>

I'm using Oracle 8<br>

<br>

Thanks

 

[MikeLacey]

I think of an inner join as something like this:<br>
<br>
Select empname, deptname<br>
From dept, emp<br>
Where emp.deptno = dept.dempno;<br>
<br>
And an outer join as something like this:<br>
<br>
Select empname, deptname<br>
From dept, emp<br>
Where emp.deptno = dept.dempno(+);<br>
<br>
In the second example rows are returned even when emp.deptno is null.<br>
<br>
Oracle versions 6, 7 & 8 supports both of these statements.<br>
<br>
Does this answer your question?<br>
<br>
Mike<br>
<p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>