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

Interview Candidate
Sep 16th, 2019
2
5383

SQL

Answer

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

sanjiwani

Sep 8th, 2020
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