Is this possible in Oracle SQL?

[Quoted] [Quoted] I wonder if anyone can help with this SQL syntax problem...

I have 2 tables linked by "ID" as follows:

Header Table                            Detail Table

ID    DATE    TOTAL                ID     ANLAYSIS_CODE    ANAL_TOTAL


----------------------------                --------------------------------


-----------------------


[Quoted] 1    10/4/00    12009                1        A
120
2    11/4/00    19098                1        B
340
3    12/4/00    23889                2        A
98
                                                   2        B
67
                                                   3        A
13
                                                   3        B

I need a query which will produce an output like this from the two tables:

[Quoted] DATE                A                    B            TOTAL


--------------------------------------------------------------


10/4/00             120                340             12009
11/4/00              98                  67             19098
12/4/00              13                  28              23889

i.e. the data in the ANALYSIS_CODE field in the detail table becomes the [Quoted] heading of a column in the results and the associated ANAL_TOTAL becomes the [Quoted] data of this column.

Is this possible in Oracle 8i ? I am lead to believe it is possible in MS [Quoted] Access using a TRANSPOSE keyword (or similar) in the SELECT statement.

Any help or suggestions would be greatly appreciated.

Thanks in advance,
--

Andrew Kendall Received on Thu Jun 01 2000 - 00:00:00 CEST