Hi Anandh
say suppose you are having following type of table structure
Emp
--------------
Id Name DeptID
and another table might be like following
Department
--------------
Id Name
now her you can do like following
SELECT
a.Name,b.Name
FROM
emp a
LEFT OUTER JOIN
dept b
ON
a.DeptId = b.Id
in this way you would be able to join them, here advantage of left join would be even if some department is missing in emp table still it will get the data of all employees
let me know