Posted by Erland Sommarskog on 06/21/82 11:51

rhaazy (rhaazy@gmail.com) writes:
> When I run this query:
> select Employeeid, tblEmployee.EmpID, OrgNode
> from tblEmployee JOIN tblEmployeeOrgNode a
> on tblEmployee.EmpId = a.EmpID,
> tblOrgSystemNode JOIN tblEmployeeOrgNode b
> on tblOrgSystemNode.OrgNOdeId = b.OrgNodeID
>...
>
> This is what I am trying to get:
> Name ID Location
> rh 1 Mano
> rm 2 Huso
> rd 3 Oso

It's good to have the table, but with out sample data and an explanation
of the table, it's difficult to make much useful out of it. It had also
help if you had included definitions of primary keys and foreign keys.

But I note your query includs a cross join with tblOrgSystemNode. This
looks suspicious. Maybe that is an error. So as a complete guess

select E.Employeeid, E.EmpID, S.OrgNode
from tblEmployee E
JOIN tblEmployeeOrgNode EON on E.EmpId = EON.EmpID,
JOIN tblOrgSystemNode S ON S.OrgNOdeId = EON.OrgNodeID

If this does not meet your requirements, please supply sample data
(as INSERT statements) and briefly explain the business rules.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]