一个非常复杂的两表查询（select）语句

Question

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. 

Answer 1

ZIP                                abcd      200 这条记录还要啊？table1和table2不是按cpmpany,IC,PCB联结吗　

Answer 2

ZIP                                abcd      200 这条记录还要啊？table1和table2不是按cpmpany,IC,PCB联结吗　

Answer 3

就是将table1加两列，将后table2里找到相对应的数据填进去。

Answer 4

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 
怎么把table1改了，昨天看到的不是这样的表结构哦? 呵呵，改简单了