DocumentQuery with JOIN and equal columns

Dmitry Bastron asked on June 3, 2016 11:53

Hi all!

I've read the article about querying with JOINs: http://devnet.kentico.com/articles/kentico-8-technology-dataquery-advanced-api

But I have a problem: what if I want to query two joined tables (A and B) having the same field names (for example "Name")? How can I achieve this with DocumentQuery? In pure SQL it will be pretty simple:

SELECT A.Name, B.Name FROM SomeTable A JOIN SomeTable2 B ON A.Id = B.KeyA

Recent Answers


Brenden Kehren answered on June 3, 2016 14:10

So the join examples in the article you referenced didn't work for your objects? What have you tried already?

1 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.