纵向数据,横向显示,急
表1
____________________________________________________________________
| plan(单号) | genre(类型) | model(型号) | total(合计) |
| | | | |
| 00100 | ic | ac105 | 100 |
| 00100 | pcb | sa200 | 101 |
| 00101 | ic | acd312 | 500 |
| 00101 | pcb | ns205 | 503 |
| | | | |
--------------------------------
表2
______________________________________________________________________
| plan(单号) | ic_model | ic_total | pcb_model | pcb_total |
| | | | | |
| 00100 |