There are two types of join inner join and outer join.

(1)Inner join will return all the common records in both the

table

Ex: Select e.ename from Employee e,Dept d where e.did=d.did;

(2)Outer join is of 3 types Left Outer,Right Outer and full

outer.

Left outer retrieves common records from both the table and

all the record from the left table.

Similarly Right Outer all the records from right table and

Full outer from both the tables