3 Replies Latest reply on Sep 25, 2013 5:20 AM by disabled_otmarkramis

    I need a query......

    kalivaraprasadm

      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......