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
1
5155

SQL

Answer

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 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
 