How to use Subquery in Where Clause Archives

October 18, 2014 - by Ahmed S

This article describes how to use subquery in where clause. SELECT Title,EmployeeID,NationalIDNumber,ManagerID FROM dbo.HumanResources_Employee WHERE EmployeeID IN (SELECT EmployeeID FROMdbo.HumanResources_EmployeeDepartmentHistory WHERE DepartmentID IN (SELECT DepartmentID FROMdbo.HumanResources_Department WHERE GroupName IN (‘Research …