This discussion is archived
2 Replies Latest reply: Dec 17, 2012 5:17 AM by Marwim RSS

How to get data in this format

949305 Newbie
Currently Being Moderated
I have two views namely
without_meeting and with_meeting

Iam getting this data from without_meeting view

IP_DISTRICT     TOTAL_APPLICATION     P1     PE
Anantapur     4     189     46
Chittoor     5     500     121
East Godavari     15     1964     275
Kadapa     10     637     111
Khammam     3     202     98
Mahaboobnagar     1     40     30
Medak     10     928     479
Nellore     5     8269     518
Prakasam     31     13353     2750
Ranga Reddy     41     15044617     2160
Srikakulam     3     122     36
Visakhapatnam     51     84483     3159
Vizianagaram     5     1039     67


I am getting data from with_meeting view

IP_DISTRICT     TOTAL_APPLICATION     P1     PE
Chittoor     37     10866411979     1001230
East Godavari     4     24589530     811166
Guntur     6     1104747     330915
Khammam     14     6282602854     677103
Krishna     2     4809298000     33940
Mahaboobnagar     3     561707     184973
Srikakulam     8     363158     183276
Visakhapatnam     63     12327008     2397861
Vizianagaram     11     3607822     514191
Warangal     7     1340630     378431


i want to club this data like in this wat
IP_DISTRICT     TOTAL_APPLICATION     P1     PE
Anantapur 4     189     46
Chittor 42 10866412479 1011351
So On...........


Please help me

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points