I need to
SELECT amount FROM table WHERE type='1' AND type='2' AND type'3'
Depending on the types, I need them to be pulled into different columns.
IF type=1 THEN amount1 IF type=2 THEN amount2 IF type=3 THEN amount3.
Is it possible to this in one statement?