Question Regarding Inner and Outer Join

Hi ,
Thanks for your reply and I understand the exact meaning of SOUNDEX function.
Like that pls explain me the difference between
INNER and OUTER Joins with exampls. ( I was totelly new to oracle).
Thank you.
Rajesh

I think best way to learn about Inner and Outer Join is by looking at the result set. Do Following.

1- Connect as SCOTT/TIGER

2- Equi Join
Select e.ename, e.sal, e.empno, d.dname, d.deptno
from emp e, dept d
where e.deptno = d.deptno

3- Inner Join
Select e.ename, e.sal, e.empno, d.dname, d.deptno
from emp e, dept d
where e.deptno(+) = d.deptno
(This will also give you the deptno that does not have any employee such as Deptno 40)


4- Update emp
set deptno = NULL
where job = 'PRESIDENT'
(This will take out the president from the deptno 10)


5- Outer Join
Select e.ename, e.sal, e.empno, d.dname, d.deptno
from emp e, dept d
where e.deptno = d.deptno(+)
(This will give you the employee who is not associated with any deptno such as President)

Also look at the following website
http://databases.about.com/library/weekly/aa022501b.htm

[Edited by irehman on 08-30-2001 at 11:02 AM]

Thank Q verymuch Ibrahim