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
So the join examples in the article you referenced didn't work for your objects? What have you tried already?
Please, sign in to be able to submit a new answer.