the sql like this:

select a.f1,a.f2, b.f3,b.f4 
from a 
left join b on a.id = b.aid 

the relation is easy to add by using RelationCollection class.

but how to get fields from two tables ?

Thank you

LLBLGen. 2.6

Use a Dynamic List.

Hello

i see. but if there are many fields , if we are using Dynamic list, it will be a big work

anyway, thank you

My table name is Kisi (English means User)

KisiCollection kc = new KisiCollection(); IRelationCollection Iliski = new RelationCollection(); Iliski.Add(KisiEntity.Relations.TelefonEntityUsingKisiId, JoinHint.Left); ExcludeIncludeFieldsList gridgoster = new ExcludeIncludeFieldsList(true);

        gridgoster.Add(KisiFields.KisiId);
        gridgoster.Add(TelefonFields.TelefonId);
        gridgoster.Add(TelefonFields.KisiId);

        kc.GetMulti(null, 0, null, Iliski,null,gridgoster,0,0);
        dgvData.DataSource = kc;

I think is your answer

Yes, great