我现在把所有需要做环比的表的字段都存放在一个表中(这个表的列很多有60多个,每个table对应几个)
tab_id
201105 550 3 5229663
201105 551 3 10529552
201105 552 3 3605265
201105 553 3 4417079
201105 554 3 3170455
201105 555 3 2204683
201105 556 3 5246651
201105 557 3 4752702
201105 558 3 6197813
201105 559 3 2053804
201105 560 3 3107892
201105 561 3 2056641
201105 562 3 1241846
201105 563 3 3317049
201105 564 3 4577868
201105 565 3 3899919
201105 566 3 2212671
201104 550 5 9651994
201104 551 5 19483088
201104 552 5 7355385
201104 553 5 8172182
201104 554 5 5911959
201104 555 5 4788864
201104 556 5 13059796
201104 557 5 10217028
201104 558 5 12897191
201104 559 5 4504138
201104 560 5 6594194
201104 561 5 4007277
201104 562 5 2476976
201104 563 5 6719748
201104 564 5 10644258
201104 565 5 9188574
201104 566 5 4374128
201105 550 4 1880418 281755 0
201105 551 4 3874711 746501 0
201105 552 4 1523400 221191 0
201105 553 4 1802280 360459 0
201105 554 4 1219083 227600 0
201105 555 4 1136849 176207 0
201105 556 4 2501755 383086 0
201105 557 4 1807127 264601 0
201105 558 4 2252585 336584 0
201105 559 4 919050 137202 0
201105 560 4 1408336 174917 0
201105 561 4 907617 142411 0
201105 562 4 595350 119665 0
201105 563 4 1397794 245533 0
201105 564 4 1966829 257930 0
201105 565 4 1682687 272521 0
201105 566 4 838355 128401 0
201104 550 6 1483681
201104 551 6 3248325
201104 552 6 979783
201104 553 6 1215260
201104 554 6 871547
201104 555 6 745235
201104 556 6 1854499
201104 557 6 1247461
201104 558 6 1598852
201104 559 6 755429
201104 560 6 988601
201104 561 6 689141
201104 562 6 466533
201104 563 6 993640
201104 564 6 1555189
201104 565 6 1388834
201104 566 6 661982
201105 550 1 230198
201105 551 1 545653
201105 552 1 181838
201105 553 1 256464
201105 554 1 167525
201105 555 1 168963
201105 556 1 281888
201105 557 1 185068
201105 558 1 230981
201105 559 1 114124
201105 560 1 137656
201105 561 1 122104
201105 562 1 79853
201105 563 1 186302
201105 564 1 190915
201105 565 1 202652
201105 566 1 94947
201105 550 2 597596 0 0
201105 551 2 1227318 0 0
201105 552 2 423430 0 0
201105 553 2 559667 0 0
201105 554 2 328007 0 0
201105 555 2 325120 0 0
201105 556 2 697930 0 0
201105 557 2 526180 0 0
201105 558 2 728228 0 0
201105 559 2 233986 0 0
201105 560 2 415469 0 0
201105 561 2 279132 0 0
201105 562 2 159917 0 0
201105 563 2 378154 0 0
201105 564 2 615985 0 0
201105 565 2 463962 0 0
201105 566 2 259646 0 0
201104 550 7 500402
201104 551 7 1724105
201104 552 7 614136
201104 553 7 488775
201104 554 7 287019
201104 555 7 218487
201104 556 7 479356
201104 557 7 487454
201104 558 7 525024
201104 559 7 208732
201104 560 7 554382
201104 561 7 254682
201104 562 7 134095
201104 563 7 574863
201104 564 7 484622
201104 565 7 347593
201104 566 7 407244
201104 550 8 239079
201104 551 8 567975
201104 552 8 186196
201104 553 8 217999
201104 554 8 162768
201104 555 8 119209
201104 556 8 239079
201104 557 8 217718
201104 558 8 260334
201104 559 8 90691
201104 560 8 132903
201104 561 8 118253
201104 562 8 65353
201104 563 8 139168
201104 564 8 203932
201104 565 8 144740
201104 566 8 102808
201104 550 9 1692574
201104 551 9 3410052
201104 552 9 1290755
201104 553 9 1284178
201104 554 9 885542
201104 555 9 860876
201104 556 9 2400447
201104 557 9 1514263
201104 558 9 2078859
201104 559 9 648639
201104 560 9 1292849
201104 561 9 823192
201104 562 9 502591
201104 563 9 1172085
201104 564 9 1940237
201104 565 9 1851630
201104 566 9 758981
201104 550 10 364355
201104 551 10 906075
201104 552 10 264697
201104 553 10 387027
201104 554 10 269917
201104 555 10 204554
201104 556 10 364437
201104 557 10 274609
201104 558 10 355780
201104 559 10 139653
201104 560 10 188417
201104 561 10 180193
201104 562 10 114371
201104 563 10 252952
201104 564 10 290945
201104 565 10 245514
201104 566 10 131435
201104 550 11 2362065
201104 551 11 4530745
201104 552 11 1758028
201104 553 11 1946042
201104 554 11 1411305
201104 555 11 1024026
201104 556 11 2239550
201104 557 11 2363295
201104 558 11 2698173
201104 559 11 899991
201104 560 11 1457483
201104 561 11 1033022
201104 562 11 609644
201104 563 11 1471324
201104 564 11 2038362
201104 565 11 1780852
201104 566 11 1089076
201104 550 12 79167
201104 551 12 154724
201104 552 12 39320
201104 553 12 46825
201104 554 12 27400
201104 555 12 30121
201104 556 12 109460
201104 557 12 29135
201104 558 12 74129
201104 559 12 15075
201104 560 12 23326
201104 561 12 26764
201104 562 12 8677
201104 563 12 20833
201104 564 12 155264
201104 565 12 47746
201104 566 12 12460
201104 550 13 965430
201104 551 13 1976534
201104 552 13 722181
201104 553 13 820555
201104 554 13 623546
201104 555 13 525400
201104 556 13 1342713
201104 557 13 918339
201104 558 13 1195541
201104 559 13 453066
201104 560 13 663234
201104 561 13 427653
201104 562 13 275527
201104 563 13 721826
201104 564 13 1099036
201104 565 13 936524
201104 566 13 423381
201105 550 5 9915785
201105 551 5 19893676
201105 552 5 7551156
201105 553 5 8312313
201105 554 5 6021125
201105 555 5 4829214
201105 556 5 13285318
201105 557 5 10340916
201105 558 5 13218574
201105 559 5 4609011
201105 560 5 6813986
201105 561 5 4075323
201105 562 5 2504506
201105 563 5 6980913
201105 564 5 10804764
201105 565 5 9326030
201105 566 5 4434827
201105 550 6 1512377
201105 551 6 3300128
201105 552 6 989867
201105 550 7 531234
201105 551 7 1098845
201105 552 7 381044
201105 553 7 506249
201105 554 7 302148
201105 555 7 240799
201105 556 7 533491
201105 557 7 497819
201105 558 7 562929
201105 559 7 260239
201105 560 7 311479
201105 561 7 260125
201105 562 7 141877
201105 563 7 347474
201105 564 7 521026
201105 565 7 376229
201105 566 7 237372
201105 550 8 246398
201105 551 8 582846
201105 552 8 193277
201105 553 8 224571
201105 554 8 167451
201105 555 8 119447
201105 556 8 247961
201105 557 8 220801
201105 558 8 273534
201105 559 8 93528
201105 560 8 140483
201105 561 8 117562
201105 562 8 66218
201105 563 8 144418
201105 564 8 211643
201105 565 8 147875
201105 566 8 105820
201105 551 8 582846
201105 552 8 193277
201105 553 8 224571
201105 554 8 167451
201105 555 8 119447
201105 556 8 247961
201105 557 8 220801
201105 558 8 273534
201105 559 8 93528
201105 560 8 140483
201105 561 8 117562
201105 562 8 66218
201105 563 8 144418
201105 564 8 211643
201105 565 8 147875
201105 566 8 105820
201104 550 10 364355
201104 551 10 906075
201104 552 10 264697
201104 553 10 387027
201104 554 10 269917
201104 555 10 204554
201104 556 10 364437
201104 557 10 274609
201104 558 10 355780
201104 559 10 139653
201104 560 10 188417
201104 561 10 180193
201104 562 10 114371
201104 563 10 252952
201104 564 10 290945
201104 565 10 245514
201104 566 10 131435
201105 550 9 1678176
201105 551 9 3373299
201105 552 9 1304400
201105 553 9 1273861
201105 554 9 886998
201105 555 9 851495
201105 556 9 2344042
201105 557 9 1516701
201105 558 9 2103018
201105 559 9 634707
201105 560 9 1320279
201105 561 9 831337
201105 562 9 494959
201105 563 9 1150067
201105 564 9 1900874
201105 565 9 1797438
201105 566 9 743941
201105 550 9 1678176
201105 551 9 3373299
201105 552 9 1304400
201105 553 9 1273861
201105 554 9 886998
201105 555 9 851495
201105 556 9 2344042
201105 557 9 1516701
201105 558 9 2103018
201105 559 9 634707
201105 560 9 1320279
201105 561 9 831337
201105 562 9 494959
201105 563 9 1150067
201105 564 9 1900874
201105 565 9 1797438
201105 566 9 743941
201105 550 10 383575
201105 551 10 951968
201105 552 10 278505
201105 553 10 401674
201105 554 10 280970
201105 555 10 211941
201105 556 10 380889
201105 557 10 296182
201105 558 10 379376
201105 559 10 145955
201105 560 10 207277
201105 561 10 188873
201105 562 10 117739
201105 563 10 264738
201105 564 10 306781
201105 565 10 258042
201105 566 10 138275
201105 550 10 383575
201105 551 10 951968
201105 552 10 278505
201105 553 10 401674
201105 554 10 280970
201105 555 10 211941
201105 556 10 380889
201105 557 10 296182
201105 558 10 379376
201105 559 10 145955
201105 560 10 207277
201105 561 10 188873
201105 562 10 117739
201105 563 10 264738
201105 564 10 306781
201105 565 10 258042
201105 566 10 138275
201104 550 11 2362065
201104 551 11 4530745
201104 552 11 1758028
201104 553 11 1946042
201104 554 11 1411305
201104 555 11 1024026
201104 556 11 2239550
201104 557 11 2363295
201104 558 11 2698173
201104 559 11 899991
201104 560 11 1457483
201104 561 11 1033022
201104 562 11 609644
201104 563 11 1471324
201104 564 11 2038362
201104 565 11 1780852
201104 566 11 1089076
201104 550 12 79167
201104 551 12 154724
201104 552 12 39320
201104 553 12 46825
201104 554 12 27400
201104 555 12 30121
201104 556 12 109460
201104 557 12 29135
201104 558 12 74129
201104 559 12 15075
201104 560 12 23326
201104 561 12 26764
201104 562 12 8677
201104 563 12 20833
201104 564 12 155264
201104 565 12 47746
201104 566 12 12460
201104 550 13 965430
201104 551 13 1976534
201104 552 13 722181
201104 553 13 820555
201104 554 13 623546
201104 555 13 525400
201104 556 13 1342713
201104 557 13 918339
201104 558 13 1195541
201104 559 13 453066
201104 560 13 663234
201104 561 13 427653
201104 562 13 275527
201104 563 13 721826
201104 564 13 1099036
201104 565 13 936524
201104 566 13 423381
201105 550 11 2391222
201105 551 11 4538431
201105 552 11 1809304
201105 553 11 1945314
201105 554 11 1419690
201105 555 11 994434
201105 556 11 2259440
201105 557 11 2372802
201105 558 11 2802938
201105 559 11 914669
201105 560 11 1532487
201105 561 11 1055555
201105 562 11 596327
201105 563 11 1480538
201105 564 11 2087162
201105 565 11 1768751
201105 566 11 1095598
201105 550 11 2391222
201105 551 11 4538431
201105 553 6 1230357
201105 554 6 883416
201105 555 6 753689
201105 556 6 1873002
201105 557 6 1259087
201105 558 6 1621397
201105 559 6 765121
201105 560 6 1005072
201105 561 6 701657
201105 562 6 473198
201105 563 6 1008375
201105 564 6 1573226
201105 565 6 1408721
201105 566 6 669913
201104 550 9 1692574
201104 551 9 3410052
201104 552 9 1290755
201104 553 9 1284178
201104 554 9 885542
201104 555 9 860876
201104 556 9 2400447
201104 557 9 1514263
201104 558 9 2078859
201104 559 9 648639
201104 560 9 1292849
201104 561 9 823192
201104 562 9 502591
201104 563 9 1172085
201104 564 9 1940237
201104 565 9 1851630
201104 566 9 758981
201105 550 1 230198
201105 551 1 545653
201105 552 1 181838
201105 553 1 256464
201105 554 1 167525
201105 555 1 168963
201105 556 1 281888
201105 557 1 185068
201105 558 1 230981
201105 559 1 114124
201105 560 1 137656
201105 561 1 122104
201105 562 1 79853
201105 563 1 186302
201105 564 1 190915
201105 565 1 202652
201105 566 1 94947
201104 550 1 223888
201104 551 1 535392
201104 552 1 177097
201104 553 1 251356
201104 554 1 163846
201104 555 1 166526
201104 556 1 275655
201104 557 1 180599
201104 558 1 225259
201104 559 1 112225
201104 560 1 134703
201104 561 1 118634
201104 562 1 78413
201104 563 1 182470
201104 564 1 186402
201104 565 1 198690
201104 566 1 92984
201105 550 2 597596 0 0
201105 551 2 1227318 0 0
201105 552 2 423430 0 0
201105 553 2 559667 0 0
201105 554 2 328007 0 0
201105 555 2 325120 0 0
201105 556 2 697930 0 0
201105 557 2 526180 0 0
201105 558 2 728228 0 0
201105 559 2 233986 0 0
201105 560 2 415469 0 0
201105 561 2 279132 0 0
201105 562 2 159917 0 0
201105 563 2 378154 0 0
201105 564 2 615985 0 0
201105 565 2 463962 0 0
201105 566 2 259646 0 0
201104 550 2 578967 0 0
201104 551 2 1189874 0 0
201104 552 2 410415 0 0
201104 553 2 544960 0 0
201104 554 2 319078 0 0
201104 555 2 318921 0 0
201104 556 2 667997 0 0
201104 557 2 513947 0 0
201104 558 2 705059 0 0
201104 559 2 227532 0 0
201104 560 2 401303 0 0
201104 561 2 271741 0 0
201104 562 2 157038 0 0
201104 563 2 365100 0 0
201104 564 2 589788 0 0
201104 565 2 448425 0 0
201104 566 2 251493 0 0
201104 550 3 5020026
201104 551 3 10235732
201104 552 3 3462255
201104 553 3 4324176
201104 554 3 3092235
201104 555 3 2177954
201104 556 3 5030517
201104 557 3 4670217
201104 558 3 5913721
201104 559 3 1957802
201104 560 3 2944791
201104 561 3 2006164
201104 562 3 1225939
201104 563 3 3092150
201104 564 3 4390153
201104 565 3 3767567
201104 566 3 2152820
201105 550 3 5229663
201105 551 3 10529552
201105 552 3 3605265
201105 553 3 4417079
201105 554 3 3170455
201105 555 3 2204683
201105 556 3 5246651
201105 557 3 4752702
201105 558 3 6197813
201105 559 3 2053804
201105 560 3 3107892
201105 561 3 2056641
201105 562 3 1241846
201105 563 3 3317049
201105 564 3 4577868
201105 565 3 3899919
201105 566 3 2212671
201105 550 4 1880418 281755 0
201105 551 4 3874711 746501 0
201105 552 4 1523400 221191 0
201105 553 4 1802280 360459 0
201105 554 4 1219083 227600 0
201105 555 4 1136849 176207 0
201105 556 4 2501755 383086 0
201105 557 4 1807127 264601 0
201105 558 4 2252585 336584 0
201105 559 4 919050 137202 0
201105 560 4 1408336 174917 0
201105 561 4 907617 142411 0
201105 562 4 595350 119665 0
201105 563 4 1397794 245533 0
201105 564 4 1966829 257930 0
201105 565 4 1682687 272521 0
201105 566 4 838355 128401 0
201104 550 4 1837840 269251 0
201104 551 4 3809968 730393 0
201104 552 4 1495790 212916 0
201104 553 4 1764510 345969 0
201104 554 4 1196722 218110 0
201104 555 4 1124523 170737 0
201104 556 4 2452048 369006 0
201104 557 4 1775409 253205 0
201104 558 4 2205368 321921 0
201104 559 4 904938 132903 0
201104 560 4 1379773 165398 0
201104 561 4 889590 134805 0
201104 562 4 587314 116422 0
201104 563 4 1369603 236374 0
201104 564 4 1924806 248557 0
201104 565 4 1652402 263056 0
201104 566 4 822279 123397 0
201104 550 5 9651994
201104 551 5 19483088
201104 552 5 7355385
201104 553 5 8172182
201104 554 5 5911959
201104 555 5 4788864
201104 556 5 13059796
201104 557 5 10217028
201104 558 5 12897191
201104 559 5 4504138
201104 560 5 6594194
201104 561 5 4007277
201104 562 5 2476976
201104 563 5 6719748
201104 564 5 10644258
201104 565 5 9188574
201104 566 5 4374128
201104 550 6 1483681
201104 551 6 3248325
201104 552 6 979783
201104 553 6 1215260
201104 554 6 871547
201104 555 6 745235
201104 556 6 1854499
201104 557 6 1247461
201104 558 6 1598852
201104 559 6 755429
201104 560 6 988601
201104 561 6 689141
201104 562 6 466533
201104 563 6 993640
201104 564 6 1555189
201104 565 6 1388834
201104 566 6 661982
201104 550 7 500402
201104 551 7 1724105
201104 552 7 614136
201104 553 7 488775
201104 554 7 287019
201104 555 7 218487
201104 556 7 479356
201104 557 7 487454
201104 558 7 525024
201104 559 7 208732
201104 560 7 554382
201104 561 7 254682
201104 562 7 134095
201104 563 7 574863
201104 564 7 484622
201104 565 7 347593
201104 566 7 407244
201104 550 8 239079
201104 551 8 567975
201104 552 8 186196
201104 553 8 217999
201104 554 8 162768
201104 555 8 119209
201104 556 8 239079
201104 557 8 217718
201104 558 8 260334
201104 559 8 90691
201104 560 8 132903
201104 561 8 118253
201104 562 8 65353
201104 563 8 139168
201104 564 8 203932
201104 565 8 144740
201104 566 8 102808
201105 550 5 9915785
201105 551 5 19893676
201105 552 5 7551156
201105 553 5 8312313
201105 554 5 6021125
201105 555 5 4829214
201105 556 5 13285318
201105 557 5 10340916
201105 558 5 13218574
201105 559 5 4609011
201105 560 5 6813986
201105 561 5 4075323
201105 562 5 2504506
201105 563 5 6980913
201105 564 5 10804764
201105 565 5 9326030
201105 566 5 4434827
201105 550 6 1512377
201105 551 6 3300128
201105 552 6 989867
201105 553 6 1230357
201105 554 6 883416
201105 555 6 753689
201105 556 6 1873002
201105 557 6 1259087
201105 558 6 1621397
201105 559 6 765121
201105 560 6 1005072
201105 561 6 701657
201105 562 6 473198
201105 563 6 1008375
201105 564 6 1573226
201105 565 6 1408721
201105 566 6 669913
201105 550 7 531234
201105 551 7 1098845
201105 552 7 381044
201105 553 7 506249
201105 554 7 302148
201105 555 7 240799
201105 556 7 533491
201105 557 7 497819
201105 558 7 562929
201105 559 7 260239
201105 560 7 311479
201105 561 7 260125
201105 562 7 141877
201105 563 7 347474
201105 564 7 521026
201105 565 7 376229
201105 566 7 237372
201105 550 8 246398
201105 552 11 1809304
201105 553 11 1945314
201105 554 11 1419690
201105 555 11 994434
201105 556 11 2259440
201105 557 11 2372802
201105 558 11 2802938
201105 559 11 914669
201105 560 11 1532487
201105 561 11 1055555
201105 562 11 596327
201105 563 11 1480538
201105 564 11 2087162
201105 565 11 1768751
201105 566 11 1095598
201105 550 12 72922
201105 551 12 164221
201105 552 12 40305
201105 553 12 45427
201105 554 12 27344
201105 555 12 29730
201105 556 12 110305
201105 557 12 29482
201105 558 12 72522
201105 559 12 14624
201105 560 12 24207
201105 561 12 23184
201105 562 12 8411
201105 563 12 20870
201105 564 12 149611
201105 565 12 45517
201105 566 12 13713
201105 550 13 972159
201105 551 13 1997288
201105 552 13 732043
201105 553 13 825611
201105 554 13 631297
201105 555 13 525746
201105 556 13 1345846
201105 557 13 922126
201105 558 13 1211006
201105 559 13 455103
201105 560 13 674128
201105 561 13 434313
201105 562 13 278115
201105 563 13 726633
201105 564 13 1107318
201105 565 13 940448
201105 566 13 425634
201105 550 12 72922
201105 551 12 164221
201105 552 12 40305
201105 553 12 45427
201105 554 12 27344
201105 555 12 29730
201105 556 12 110305
201105 557 12 29482
201105 558 12 72522
201105 559 12 14624
201105 560 12 24207
201105 561 12 23184
201105 562 12 8411
201105 563 12 20870
201105 564 12 149611
201105 565 12 45517
201105 566 12 13713
201105 550 13 972159
201105 551 13 1997288
201105 552 13 732043
201105 553 13 825611
201105 554 13 631297
201105 555 13 525746
201105 556 13 1345846
201105 557 13 922126
201105 558 13 1211006
201105 559 13 455103
201105 560 13 674128
201105 561 13 434313
201105 562 13 278115
201105 563 13 726633
201105 564 13 1107318
201105 565 13 940448
201105 566 13 425634
根据tab_id查询出不同的记录,但是列很多是空值,我只想显示tab-id需要做环比的字段(0或>0e的数据)