table: pivotedtable amount |key1 |key2 | ========================== 10 |one |un | 12 |two |deux | 13 |one |deux | 14 |two |un | create table pivotedtable (amount real, key1 varchar(5), key2 varchar(5)); insert into pivotedtable values (10,'one','un'); insert into pivotedtable values (12,'two','deux'); insert into pivotedtable values (13,'one','deux'); insert into pivotedtable values (12,'two','un'); insert into pivotedtable values (2, 'two','un'); \ key1|one |two | \ | | | key2\ | | | ======\=========== un |10 |14 | deux |13 |12 | Amount
-0-