Month     Revenue  Jobcode
01/31/07 209220   45456
02/28/07 2233221  45664
...ETC

Jobcode January February March...etc
      45456    5644     54545    544
      45457    6654545  45545    54545

SELECT a3.jobcode,
  january,
  february
FROM
  (SELECT a1.jobcode,
     SUM(january) AS
  january,SUM(july) AS
  july

   FROM
    (SELECT mtdrev AS
     january,
       jobcode
     FROM forecast_data
     WHERE to_char(to_date(period,    'mm/dd/rr'),    'mm') = '01')
  a1,
      (SELECT jobcode,
       mtdrev AS
     july
     FROM forecast_data
     WHERE to_char(to_date(period,    'mm/dd/rr'),    'mm') = '02')
  a2
   WHERE a1.jobcode = a2.jobcode
   GROUP BY a1.jobcode)
a3

SELECT EXTRACT(YEAR FROM order_date) year, order_mode, order_total FROM orders)
PIVOT
(SUM(order_total) FOR order_mode IN ('direct' AS Store, 'online' AS Internet));