Hi,
how can I create queries with TExpressions which include multiple tables?
Let's assume I want to retrieve a list of objects of type A which are (in the object graph) connected to some others, and I have B as starting point.
In SQL my query would like this:
select A.* from A, B, C, D
where
B.ID = {b_ID}
and C.ID_F = B.ID_F
and A.ID_C = C.ID
and A.ATTR = B.ATTR
and A.ID = D.ID_A;
In Delphi, using Aurelius, I'd prefer to do this with expressions somehow, but can't figure out the exakt way to do it.
Any help appreciated.