Hi, I guess, this may not turn out to be correct always. If it is done in a transaction and both of the entities are in the same entity group, then this will work.
-Aswath On Sat, Jun 12, 2010 at 8:24 PM, RAVINDER MAAN <[email protected]> wrote: > Instead of getting these values with query best option is to store this > values when you add new employee.So create one more dataset with fields > city, area and employeecount.whenever you add new employee update the count > .then you can get the count with simple query > select employeecount from <newdataset> where city==<city> && area==<area> > > > > On Sat, Jun 12, 2010 at 8:05 PM, Vik <[email protected]> wrote: > >> Hie >> >> I have following data set: >> >> City, Area emp-name >> >> and have to write a query which shows number of employees by city and >> area. So data should display like: >> >> Delhi rohini 5 >> Delhi nehru 10 >> Hyd madhapur 6 >> Hyd hitech 24 >> Cheanni park 20 >> >> >> So what the query should be? Please advise >> >> Thankx and Regards >> >> Vik >> Founder >> www.sakshum.com >> www.sakshum.blogspot.com >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google App Engine for Java" group. >> To post to this group, send email to >> [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<google-appengine-java%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/google-appengine-java?hl=en. >> > > > > -- > Regards, > Ravinder Singh Maan > > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-appengine-java%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
