Need to find the list of employees who is from Finance department having 1200 pincode
Employee table has : Emp.Name, Emp.ID, Dep.ID & Location ID
Department Table has: Dep.ID, Dep. Name
Location table has: Location ID & Location Pincode Need to find the list of employees who is from Finance department having 1200 pincode
SELECT Emp.name, Dep.Name, Location Pincode FROM
Employee JOIN Department on Dep.ID.Employee = Dep.ID.Department
JOIN Location on employee.Location ID= Location.Location ID where Dep. Name= finance and Location Pincode =1200
Code
SELECT Emp.name, Dep.Name, Location Pincode FROM
Employee JOIN Department ON Dep.ID.Employee = Dep.ID.Department
JOIN Location ON employee.Location ID= Location.Location ID WHERE Dep. Name= finance AND Location Pincode =1200
Need to find the list of employees who is from Finance department having 1200 pincode
Department Table has: Dep.ID, Dep. Name
Location table has: Location ID & Location Pincode
Need to find the list of employees who is from Finance department having 1200 pincode
Related Answered Questions
Related Open Questions