Personally I think you are taking the wrong approach. Think about you data model as a set of objects/entities and their relationships and not as relation tables.
Not knowing what you exactly trying to do means the following example is probably wrong, ie I don't know if you have a one to one relationship between business and user but if you do use references ie user.business is a referenproperty pointing to a business You can fetch the object in either direction, business.user_set() will return all users that refer to the business and user.business will return the business. Have a think in those terms, then you don't have to do joins. You may have to in some case create an intermediate entity that references multiple entities . T On Mar 22, 8:16 pm, arnie <parvez...@rediffmail.com> wrote: > I have certain tables in datastore that are related to each other. say > user table is related to Business table. How can we use a single query > to fetch data from these tables at onece, say for a userid=2 we need > the record from user table as well as from Business table with > matching userid. I have seen that we cannot use sql like joins here in > gql. > So how can we construct a single query to get the desired records > Thanks > Arnie --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---