Hi Rich
Tried this again in VFP 9 and it worked ok ??
However does not work in VFP 8 !!
I can work with this and deploy with VFP9
Many thanks again for your help
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