4 Replies Latest reply on Mar 2, 2014 11:11 PM by gdildine

    Using join in the query statement in map builder


      Hi All,


      I have two tables one which has the geometry for the spatial feature and one which has the attributes for the spatial feature. I would like to use a join in my select statement in map builder.Following is my statement.


      select key as code,NVL(Sales,0),geometry

      from   table b left outer join


      Select code,sum(n_ext_attr1) as Sales

      from table c

      group by code) a

      on b.key=a.code;