Hi Borislav,

you have all Table1 records only with:

>SELECT Table1.*,Table2.Name AS T2Name FROM Table1 LEFT JOIN Table2 ON Table1.Key1 == Table2.Key1 AND Table2.ChildKey <> cChild INTO CURSOR Test

Fabio