I have following Nested Join whcih works fine:

SELECT Bal_Link, Bal_Linkb, Bal_Val ;
FROM TableA ;
WHERE Bal_link IN ;
(Select Bal_link FROM TableA WHERE BAL_LINKB = X)


I now want to Do an Inner Join of the Above result with another Table,all incorporated into the one Select Command
I.e. I'll end up I think with Two Nested Joins

Anyone know if this is possible ?

Tia
Gerard