>>>Becuase I hate to see in my code:
>>>NVL(Field,0000000.00) AS ...
>>>I use new VFP9 function CAST. No the answer is in how join these tables. I used left join, you only JOIN
>>>That way I get in the result cursor (w/o gouping)
>>>

>>>ID   Tbl2.PK  Tbl2.Sumv  Tbl3.PK    Tbl3.Sumv
>>>1       1       200        2           200
>>>1       NULL    NULL       3           400
>>>

>>>
>>
>>This is where I see different results, not in your example, but my actual code with my tables. When I use LEFT JOIN I see no NULL values in the resulting query. That's what puzzles me. Table2 has only 1 record matching the PK field. Therefore, it should have NULL values in the second record but it doesn't.
>
>You must remove GROUP BY to see them

I did remove the GROUP BY. And I tried to change the order of LEFT JOIN of Table2 and Table3 but still no matter what I do, I see two records in the resulting query. And for the fields of the Table2 these records are identical.