Left Outer Join with Images

First Create Emp Table

create table Emp(E_Id int, E_Name varchar(30),E_Salary int)

Insert into Emp values(1,'Vikas',14000);

Create Department Table

create table Emp_Department(EmpId int primary key,DName varchar(20));

insert into Emp_Department values(1,'web Development');

Left Outer Join

select a.E_Name as Employee_Name,b.DName as

Department_Name from Emp a left outer join

Emp_department b on a.E_id=b.Empid