I think you should create a new entity which has kind1_key kind1_prop kind2_key kind1_ref kind2_ref
Filter on kind2 key, kind 1 key , kind1 prop The use the refs to get the real objects when you need to. Or something like that T On Feb 27, 4:09 am, Devel63 <danstic...@gmail.com> wrote: > Until now, the lack of a SQL-like join capability has not been an > issue. But... > > I have 2 entity kinds: > - kind1: prop1 > - kind2: username, reference_to_kind1 > > I want to find all kind2's where user=me and reference_to_kind1 is a > kind1 where prop1 = specific_value. > > I can't figure out a way to do this except to start with either class, > do a fetch, then iterate over all references. This is potentially A > LOT of individual queries. The intersection/join is small, but each > kind can have large numbers of entities. > > How is this done? > > P.S. Please don't suggest denormalization, because the above is a > simplified example. I am really doing this with text fields in kind1, > and keyword searchables. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---