Hi All,

Please help me to do inner join with the following query.


SELECT ln.node_Id,
ln.node_Name,
tn.node_Id,
tn.node_Name,
pn.node_Id,
pn.node_Name,
e.emp_Id,
e.emp_first_Name,
e.emp_last_Name,
FROM Node pn

Inner Join Node tn

On pn.node_Id = tn.node_parent_Node_Id
Inner Join Node ln

ON ln.node_parent_Node_Id = tn.node_Id

Inner Join employee e,training tr
ON e.emp_Id = tr.trng_trainee_Id

In the above query the area marked in Red Color is giving problem for me.

How to join more the one table in the same inner join because tbe ON condition in the next line to the Inner Join, Includes two new tables employee e and training tr

which are not referred previously.

Please Help. Its urgent for me.

Thanks and Regards,

R. Sangeetha Priya


DB2 & UDB email list listserv db2-l LazyDBA home page