I have a situation where I want to code a query for a dynamic list that replicates the following SQL query:

select Table1ID from Table1ID join Table2 on Table1.Table1ID = Table2.Table1ID join Table3 on Table1.TypeCode = Table3.TypeCode where ...(some filter stuff hidden)

The problem is the join between Table1 and Table3. TypeCode is NOT a primary key or foreign key on either table. It is, in fact, the worst of all possible joins -- no formal constraint between tables, and these columns are varchars.

This problem will be fixed in future versions of the system, but for now I have to support this mess.

Is this easily done in LLBLGen Pro querying?

--Bruce

UPDATE: I figured out how to add an entityrelation manually!