I have table with following structure:
Cust Amount Type
1 150.00 1
1 100.00 2
I would like to get query result:
Cust Type1 Type2
1 150.00 0.00
1 0.00 100.00
How to do this with query?