How to write a sql query

Hi All

   How to write a sql query to print in the matrix report. Eg . Test table .

       a1    b1
        1     2.3
        1     3.5
        1     7.0
        2     1.7
        2     2.6
        2     2.9
        3     1.3
        3     2.9
        3     3.0

I need the output ,should be

     1           2.3      3.5     7.0
     2           1.7.     2.6     2.9
     3           1.3      2.9     3.0

Please , Any one suggest me how to write a sql query for this.

Thanks & Regards Received on Wed Nov 22 2000 - 05:34:33 CST