Hello, I would like to implement this sql statement in LLBLGen:

Select tbl1.*,tbl2.* from tbl1,tbl2 where
tbl1.id = 1 and

//I don´t know how to implement the following line
//because I can´t define this relation in the editor

tbl1.name = tbl2.name

note: the columns tbl1.name and tbl2.name are not the PK or the FK. This 2 columns have the type string which I need to compare.

Can you please help me ?

Slowhand

You should create an EntityRelation object in code. How to do that is in the generated relation classes. (you don't have to pass inheritance info if the fields aren't in an entity in an inheritance hierarchy). Then add the relation object to a normal relationcollection and create your filter