Combine columns from two select statements to one output table (join not possible!)

[gandolf989]

If you are trying to get the rows from both tables,
but the data is different then you want a union all.

select *
  from ( select sum (brutto) as b1, sum (netto) as n1
           from table 1
          where order_date between '19.09.11' and '19.12.11'
          union all
         select sum (brutto) as b2, sum (netto) as n2
           from table 1
          where order_date > trunc(add_months(sysdate,-3)))
 order by 1;