Thanks your answer but it just for get result of itineraries base on location id.
In my case I want to load list locations which have itinerary reference.
Ex: I have 4 Locations A, B, C, D
I insert Itinerary 1 relate to A
I insert Itinerary 2 relate to B
=> I expect to get result A and B.
C and D not in list because not have Itinerary
In SQL I can use Inner Join to list those locations(A,B). But in backendless I not find the way to get it yet.
Hope you understand my explain.
Hi Mark
Sr about my explain is not good.
I think you still not get my case. I just want to get locations is referenced to itinerary. Can you look again my tables?
Or can I “Select distinct location.id from Itinerary” so I can get list Location is referenced to itinerary.