insert into EmployeeLeavesList select em.Empid,LeaveId,LeaveCount from Leavesperyear as le , EmployerMaster as em where le.Empid=em.Empid
SELECT A.Col1, A.Col2, B.Col1, B.Col2 INTO Table3 FROM Table1 A INNER JOIN Table2 B ON A.Col1 = B.Col1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)