How to join multiple tables by multiple columns using DynamicQuery?

[Kurt Xu, geändert vor 10 Jahren.]

I want to join multiple tables by multiple columns using DynamicQuery, but don't know how to do it. Say there are 2 tables, expandocolumn,expandovalue.

expandocolumn:
companyId
tableId
...

expandovalue:
valueId
companyId
tableId
...

I want to join expandocolumn to expandovalue by companyId and tableId using DynamicQuery API, is that possible to generate
expandocolumn.companyId=expandovalue.companyId and expandocolumn.tableId=expandovalue.tableId? Moreover, how to straight to get ExpandoValue and ExpandoColumn objects from the result?
Thanks

[Rahul Pande, geändert vor 10 Jahren.]

Hi Kurt,

Please have a look at this link.

HTH
Rahul

[Kurt Xu, geändert vor 10 Jahren.]

Rahul Pande:

Hi Kurt,

Please have a look at this link.

HTH
Rahul

Hello Rahul, I've researched the thread before, but it only talked about how to use just one column to join tables ,not two. And it uses subquery, not the shape of table1.a=table2.a .