Support Topics Documentation Slack YouTube Blog

Query like inner join , nested query

Hi
i have 3 table :

ProductTable
OrderTable [ with product_id , user_id ]
UserTable

i want to get OrderTable Rows involve user details [ name ,… ]and product details [ name , … ] with one request to Backendless api

how i can reach to this goal ?

Hi @hamid_jahandideh

Have you read about relations between Data tables in Backendless? If not:

So in your case you would need to have a relation from table OrderTable to the other two tables (ProductTable, Users). Then when all relations between rows will be set - you will need to run a GET request against OrderTable table. If you face any difficulties later on - do not hesitate to ask additional questions here or in our Slack channel

Anton