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
  • 1
  • 3024

  
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
  1. SELECT Emp.name, Dep.Name, Location Pincode FROM 

    2. 

  2. Employee JOIN Department ON Dep.ID.Employee = Dep.ID.Department

    3. 

  3.               JOIN Location ON employee.Location ID= Location.Location ID WHERE Dep. Name=  finance AND Location Pincode =1200

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions