Joins In Sql Server

Table


Query
Inner Join

select * from car as a inner join
Dept as b On a.CarId=b.id

Outer Join -Full

select * from Emp as a full outer join
Dept as b On a.Id=b.id

Left
select * from Emp as a left outer join
Dept as b On a.Id=b.id

Right
select * from Emp as a right outer join
Dept as b On a.Id=b.id

Result