–Self Join
select *from emp as p where p.salary=p.gsalary
–Equi Join
select d.*, e.* from dept as d , emp as e where d.id=e.deptids
–Inner Join
select d.*, e.* from dept as d inner join emp as e on d.id=e.deptids
–Outer Join
–Left Outer Join
select e.*, d.* from emp as e left join dept as d on d.id=e.deptids
–Right Outer Join
select d.*, e.* from dept as d right join emp as e on d.id=e.deptids
–Cross Join
select d.*, e.* from dept as d , emp as e