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

    Using join in the query statement in map builder

    NathanT

      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;