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:

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.