Hello.
I’ve been reading the backendless documentation regarding the database relations.
I’ve found that’s not user friendly at all. I’ve read it more than once and am still confused how to inner join two tables.
Is there any way to input the query, as a queryOption like “inner join table x on table y” and so on, like a normal SQL query?
Hi, Ivan.
What do want to get ?
In our API you work with object representation - not SQL tables.
Whatever it was, you should use relations, to bind to tables. Then you can get object from the table and check fields from the related table.
The closest to inner joins is the ability to retrieve related objects. As for the classic inner join support, it is not available. Did you understand how retrieval of related objects works?