Formin sql query + Android
Posted by: chanchal kumari
Date: August 03, 2012 01:49AM

Hi,
In my android app, I am getting a list of nearby restaurants from Google Place API.

But unfortunately, this list does not give menus of the restaurant.

I have T_RESTAURANT and T_MENU tables.

Lets say, I get 4 restaurants in the list returned by API, then how should I make my query to extract data.

If I do:
select name, votes, review from T_MENU where restaurant_name = REST_NAME_1;
and I have to fire this query for each of the restaurants i.e. 4 times in this case.

Can anyone suggest me a good solution?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Formin sql query + Android
August 03, 2012 01:49AM
August 03, 2012 10:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.