Web
Analytics
sql joins in sql server - Tutorial

For Consultation : +91 9887575540

Stay Connected :

–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

Select your currency