Home Forums Article Discussions Article Discussions by Author Discuss content posted by Brian Ellul Sub query expressions vs. Joins. RE: Sub query expressions vs. Joins.
IG
Grasshopper
Points: 13
More actions
January 20, 2012 at 12:30 am
#1436297
Why not the following?
SELECT a.EmployeeID,a.Salary a.RActive
b.ManagerName
FROM Employees a (nolock)
,Managers b (nolock)
WHERE b.ManagerID = 1
AND a.ManagerID = b.ManagerID;