一个非常复杂的两表查询(select)语句
table1
Company IC Total1 PCB Total2
IBM A2051 200
IBM 12ad 300
IBM ded22 220
IBM aed45 220
Lenovo adde2 500
Lenovo 15a 100
Lenovo ad33 0
ZIP abcd 200
ZIP addf 0
----------------------------------------------------------
table2
Company PlanNum Complete IC PCB Total
IBM 100 50 A2051 100
IBM 100 50 12ad 190
IBM 200 170 ded22 200
IBM 200 170 aed45 200
Lenovo 80 80 adde2 80
Lenovo 80 80 15a 80
-------------------------------------------------------
Result TB1
Company PCB Total11 total12 IC Total21 Total22
IBM A2051 200 50
IBM 12ad 300 140
IBM ded22 220 30
IBM aed45 220 30
Lenovo adde2 500 0
Lenovo 15a 100 0
ZIP abcd 200
说明:table1和table2按cpmpany,IC,PCB联结,
如果Table2里的PlanNum小于Complete,则用Table2里的Total-Complete的值填入Total12和Total22.