Hi JM, Think this sub-query feature is covered by PHOENIX-1168, for which a check-in is expected very soon.
Thanks, Maryann On Wed, Sep 24, 2014 at 9:06 AM, Jean-Marc Spaggiari < [email protected]> wrote: > Hi, > > Is it possible to run sub-queries with Phoenix? Something like this: > > select * from "metadata" n where L = 1 AND R = (select max(R) from > "metadata" z where n.A = z.A); > > Goel is to get all lignes where L=1 and R=max. Field "A" is the key. > > Thanks, > > JM > -- Thanks, Maryann
