use employees
create table employee
(
   empid char(2),
   empname varchar(40),
   primary key(empid)
)
create table location
(
   empid char(2),
   emploc varchar(40),
   primary key(empid)
)

use employees
insert into employee
(empid, empname)
values
('13','Jason'),
('08','Alex'),
('03','Ram'),
('17','Babu'),
('25','Johnsonn')

use employees
insert into location
(empid, emploc)
values
('13','San Jose'),
('08','Los Angeles'),
('03','Pue , India'),
('17','Chennai, India'),
('39','Bangalore, Indai')


select *
from dbo.employee e
inner join dbo.location l
on e.empid = l.empid

select *
from dbo.employee e
left outer join dbo.location l
on e.empid = l.empid

select *
from dbo.employee e
right outer join dbo.location l
on e.empid = l.empid

select *
from dbo.employee e
full outer join dbo.location l
on e.empid = l.empid