SQL Question

From: Craig Grell <craigg_at_thewebmarket.com>
Date: Tue, 18 Jan 2000 14:16:33 -0700
Message-ID: <3884d930_2_at_news.cadvision.com>

[Quoted] [Quoted] I have a table with the following structure.

start date, month1_data, month2_data, month3_data, month4_data, month5_data, [Quoted] month6_data

with the following information

'01-JAN-2000', 1000, 1500, 1200, 1900, 1400, 900
'01-FEB-2000', 200, 400, 300, 600, 300, 100
'01-MAR-2000', 1100, 1700, 1600, 1200, 1000, 700
How can I select this information to make the monthly data align so that the [Quoted] [Quoted] result of the select would look like the following when aligned on the date
'01-JAN-2000'

'01-JAN-2000', 1000, 1500, 1200, 1900, 1400, 900
'01-JAN-2000', 0, 200, 400, 300, 600, 300
'01-JAN-2000', 0, 0, 1100, 1700, 1600, 1200
[Quoted] Thank you for any suggestions

Craig Received on Tue Jan 18 2000 - 22:16:33 CET