Hi Rich. Many thanks for your reply

However, when I try to run it , I get a Syntax error on the 3rd line:
......JOIN (SELECT Bal_Link, Bal_Linkb, Bal_Val ;

Regards,
Gerard


>>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