AnsweredAssumed Answered

I need a query......

Question asked by kalivaraprasadm on Sep 20, 2013
Latest reply on Sep 25, 2013 by disabled_otmarkramis

HI,

 

 

I have one table like this...

 

 

Account Ins_type1 charges payments

-----------------------------------------------------------

1 primary 500 500

1 secondary 200 200

2 secondary 300 300

3 primary 600 400

3 secondary 500 500

3 Tertiary 100 100

4 Tertiary 200 200

5 Secondary 700 700

5 Tertiary 400 400

 

 

But I wnat to output like the following format....

 

 

Account Ins_type1 charges payments Ins_type2 charges payments Ins_type3 charges payments

----------------------------------------------------------------------------------------------------------------------------------------------------------

1 primary 500 500 secondary 200 200 null null null

2 null null null secondary 300 300 null null null

3 primary 600 400 secondary 500 500 Tertiary 100 100

4 null null null null null null Tertiary 200 200

5 null null null Secondary 700 700 Tertiary 400 400

 

 

 

 

Please any one help me......

Outcomes