Inner and Outer Joins In Oracle 1

[kavi]

Can someone tell me the difference between an inner join and an outer join? Also if you have any good references or web sites where they have info about SQL Statements please let me know .<br>Thanks

 

[MikeLacey]

Select empname, deptname<br>From emp, dept<br>Where emp.deptno = dept.deptno<br><br>That's an inner join - nothing wrong with it - but if there's a null emp.deptno the query will skip that record altogether.<br><br>Select empname, deptname<br>From emp, dept<br>Where emp.deptno = dept.deptno (+)<br><br>That's an outer join, will return blank deptname for emp recs with a null emp.deptno<br><br> <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

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