title: how to union two table in obiee?
body: <p>I have two tables in my physical layer(due some reason) although I konw it's better two union two tables.Table A and Table B has same structure。I aim to implement a sql like：</p>
  
  <pre><code>select F1，F2 
       from (select *
             from tableA
             union
             select *
             from tableB)
  tableMix
  </code></pre>
  
  <p>just union two factor table...how can I do it in Admin tools?</p>
  
  <p>now the nqquery like that</p>
  
  <pre><code>WITH SAWITH0 AS
      ((select T3580.AMOUNT as c1, T30887.YEAR_DESC as c2, T30887.YEAR_WID as c3
        from DW_DAY_D T30887 /* A_Dim_DW_TQ_DAY_D */, DW_TQ_PRODUCT_F T3580 /*                    A_Fact_DW_TQ_PRODUCT_F */
        where (T3580.DAY_ID = T30887.DAY_WID)
        union all
        select T120596.AMOUNT   as c1,
        T30887.YEAR_DESC as c2,
        T30887.YEAR_WID  as c3
        from DW_DAY_D T30887 /* A_Dim_DW_TQ_DAY_D */, DW_MHG_PRODUCT_F T120596 /*      A_Fact_DW_MHG_PRODUCT_F */
        where (T30887.DAY_WID = T120596.DAY_ID))),
        SAWITH1 AS
       (select distinct D3.c1 as c1, D3.c2 as c2, D3.c3 as c3 from SAWITH0 D3)
       select distinct 0 as c1, D2.c2 as c2, D2.c1 as c3, D2.c3 as c4
       from SAWITH1 D2
       order by c4, c3
  </code></pre>
  
  <p>but I can't set the aggration rule as 'sum' on 'amount'.</p>