>>>>It was exactly your sample.
>>>
>>>Not sure why it didn't work - AFAIK it should. Ok, if I can find VFP9 somewhere I'll test.
>>>
>>>Thanks.
>>Tested www.microcomplex.com/temp/Test.jpg ;o(
>
>I am sorry, I cannot use links here. What did you get?

Ok, everyone, my fault - I forgot to name the derived table. I somehow more used to select ... from inner join ( ) slq1 technique.