I want to use an inner join query with Java and Azure mobile apps, but it looks like api does not let it do operations among the tables. Is there any way to do it?
List<ToDoItem> result = table.where()
@shanks, There is a similar SO thread Implementing table joins in the Mobile Apps Node.js backend using SQL which has been answered and you can refer to.
Assumption that using Node.js as the backend of Azure Mobile App, the steps as below:
azureMobile.data.executewith the query of inner join SQL or the query for a view created with inner join sql. You can refer to the subsection
How to: Execute custom SQL statementsof the section
How to: Call a custom API.