help with a query

From: Jorge Castro <jrcastro_at_ceibo.entelnet.bo>
Date: Tue, 22 Aug 2000 20:10:26 GMT
Message-ID: <8nummv$9tf$1@nnrp1.deja.com>

Hi everyone. I need help.

I have this data in a table:

TYPE ID VALUE
---------- ---------- ----------

         1          0       5000
         1         11        500
         1          9         25
         1          8        800
         1         10          0
         1          7        200
         2          6       85,5
         2          5    1068,75
         2          4     676,85
         1          3         15
         1          2       2000
         1          1         10
         0         19          0
         0         24          0
         0         20          0
         2         14          0
         1         13          0
         1         12          0
         2         18         45
         2         17         45
         2         16         20
         2         15        456
         0         21          0
         0         23        100
         0         22          0

and I want to make a query that show it like this:

TYPE1 VALUE1 TYPE2 VALUE2 TYPE0 VALUE0
---------- ---------- ---------- ---------- ---------- ----------

         0       5000          4     676,85         19          0
         1         10          5    1068,75         20          0
         2       2000          6       85,5         21          0
         3         15         14          0         22          0
         7        200         15        456         23        100
         8        800         16         20         24          0
         9         25         17         45
        10          0         18         45
        11        500
        12          0
        13          0

anyone can help me. Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 22 2000 - 15:10:26 CDT