>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