create table Employee(Empid varchar(255),Ename varchar(255),salary int,Dept_id int);
insert into Employee(Empid,Ename,salary,Dept_id)values(101,"Anurag",12000,01),(102,"Anshu",10000,01),(103,"Manav",15000,02),(104,"Ankur",8000,03);
create table Department(Dept_id int,Dname varchar(255));
insert into Department(Dept_id,Dname)values(01,"Finance"),(02,"Marketing"),(03,"Packing");
select * from Employee;
select * from Department;
select Employee.EmpId, Employee.Ename, Department.Dept_id, Department.Dname from Employee left join Department
on Employee.EmpID=Department.Dept_id;