helal.mobasher 13209 (11/27/2012)

---

I am linking two tables with left outer join. I need to keep all the records in the left table even though there are no matches in the right one. I thought that's the purpose of using left outer join. Here is the example: tab1 ID=ranges from 01 to 10 and tab2 ID ranges from 01 to 10 with missing IDs.

select ID, Name

from tab1 t1

left outer join tab2 t2 on t1.id=t2.id

results:

t1.id,t1.name

01,A

02,B

03,C

06,F

08,I

since t2.ids 4,5,7,9,,10 are missing, these records are excluded from the result set.

Any help will be greatly appreciated.

Thanks,

Helal