SQL help!

From: KTL <webmaster_at_rs-net.com>
Date: Mon, 19 Jul 1999 09:24:36 -0400
Message-ID: <37932714.16EA1282@rs-net.com>

I need to return a result set for this year/last year data.. all from the same table..
I need the information in the same line.. How do I do this in Oracle?

SELECT week_nbr,

        week_dsc,
        store_nbr,
        store_name,
        sum(nvl(regsales,0)) as ty_reg_sales,
        null,
        sum(nvl(regunits,0)) as ty_reg_units,
        null,
        sum(nvl(promosales,0)) as ty_promosales,
        null,
        sum(nvl(promounits,0)) as ty_promounits,
        null

 FROM RSNET.JC_STORE_BY_WEEK
 WHERE week_nbr >= 199828 and week_nbr <=199927

 UNION  SELECT week_nbr,

        week_dsc,
        store_nbr,
        store_name,
        null,
        sum(nvl(regsales,0)) as ly_reg_sales,
        null,
        sum(nvl(regunits,0)) as ly_reg_units,
        null,
        sum(nvl(promosales,0)) as ly_promosales,
        null,
        sum(nvl(promounits,0)) as ly_promounits

 FROM RSNET.JC_STORE_BY_WEEK
 WHERE week_nbr >= 199728 and week_nbr <=199827  GROUP BY week_nbr,week_dsc,store_nbr,store_name  ORDER BY week_nbr,store_nbr

The nulls are there as place holders so the other query can fill the value...

suggestions?
-Ken Received on Mon Jul 19 1999 - 08:24:36 CDT