Viewing 2 posts - 1 through 3 (of 3 total)
I received the solution from another forum:
SELECT EmpName, E.EmpID
FROM Employee AS E
JOIN EmployeeOrg AS EO
ON E.EmpID = EO.EmpID
WHERE OrgID IN ('1', '2', '3')
GROUP BY EmpName, E.EmpID
HAVING COUNT(DISTINCT OrgID)...
October 7, 2009 at 9:41 pm
#1063227
Rudy of r937.com replied on another forum with the following answer, which worked!
[font="Courier New"] SELECT E.EmpName , A.OrgName , EA.OrgID FROM Employee...
August 31, 2009 at 7:10 pm
#1047261