Is there anyway i can join one entity to another, using a modified key? For instance, i want to join EntityA.ID with EntityB.ID, but i want to add 100 to EntityA.ID before the join. Is this possible?

Hi squirmin, could you post the llbl version and model you're using as well as the sql-query you want to reproduce?

i'm using version 1.0.2005.1 and using the adapter model. i want to produce a query similar to the following:

select * from tbl_one a join tbl_two b on a.id = b.id+100

thanks.

When using the entityRelation to join between these entities, set the CustomFilter to the specific filter, and set CustomFilterReplacesOnClause to true