Q. Write a query to fetch employee names and salary records. Return employee details even if the salary record is not present for the employee.

Answer:  SELECT Emp.FullName, S.Salary

FROM EmployeeDetails E LEFT JOIN EmployeeSalary S
ON Emp.EmpId = S.EmpId;

Leave a Reply

Your email address will not be published. Required fields are marked *