Today I looked into Outer Joins and Inner Joins. I have never used joins (Explicit) always relied on the Implicit joins created by the where clause.

In Outer Joins we have Right Outer Joins and Left Outer Joins and Full Outer Joins. What this basically means is that if there is as foll:

Left Outer Join:
All the records in the first table will be displayed even though there is no corresponding records in the second table.

Right Outer Join:
All the records in the second table will be displayed even though there is no corresponding record in the first table.

Full Outer join.
All the records of both the table will be displayed.

A Good example is given here.
Join (SQL) – Wikipedia, the free encyclopedia