>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
How about.....
SELECT othertable.*,firstjoin.bal_link,firstjoin.bal_linb,firstjoin.bal_val;
FROM othertable;
JOIN (SELECT Bal_Link, Bal_Linkb, Bal_Val ;
FROM TableA ;
WHERE Bal_link IN ;
(Select Bal_link FROM TableA WHERE BAL_LINKB = X) ) firstjoin;
ON othertable.keyfield = firstjoin.keyfield