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!