Employee table:
EmployeeID Name Departmentid
1 a 1
2 b 1
3 c 3
Department table:
Departmentid Departmentname
1 IT
2 HR
Query to get the details Employeeid,name,departmentname using correlated query and where exists
Mark as Answer if its helpful to you
---
Srihari