How to use join query in iOS using parse framework?

Question

I have two tables:

1.) User:name,age,address-id

2.) Address: address-id,street-name,city,state

How can I get the list of users with address using JOIN query?

like

SELECT User.name, User.age, Address.street-name, Address.city, Address.state FROM User INNER JOIN Address ON:User.address-id=Address.address-id;

How can I get data from this two tables in one query?

Answer 1

You cannot do a JOIN query directly, as the database backing parse.com is not a SQL database but a NoSQL database.

In your particular case, all you need to do is include the address in the user query:

PFQuery *query = [PFQuery queryWithClassName:@"User"];  // Or [PFUser query] if users are PFUsers
[query whereKey:@"someKey" equalTo:@"someValue"]; // Whatever you need to get a correct list of users
[query includeKey:@"address-id"];  // This includes all related Address objects in the result set
[query findObjects];  // Or preferably findObjectsInBackgroundWithBlock

This assumes that your address-id property is a relation or pointer.