心急如火!!馬上給分!!

[wuzongjie]

有兩個表Table1,Table2:
Table1的記錄如下：
goodsid speakid speakcount remark
TMB1049 0123 400 'dd'
TMB1055 0125 200

Table2的記錄如下:
goodsid speakid sendcount
TMB1049 0123 0
TMB1055 0125 100

通過查詢
select Table1.goodsid,table1.speakid,
table1.Speakcount-table2.sendcount as yucount,table1.remark
from Table1,Table2
where Table1.goodsid=Table2.goodsid

得出結果：
goodsid speakid yucount remark
TMB1049 0123 400 'dd'
TMB1055 0125 100

如何通過這個結果集修改''REMARK''，然後把修改到的‘REMARK’值更新到''TABLE1''

即：修改後的結果
goodsid speakid yucount remark
TMB1049 0123 400 'cc'
TMB1055 0125 100 'xx'
然後查詢TABLE1得出的結果為：

goodsid speakid speakcount remark
TMB1049 0123 400 'cc'
TMB1055 0125 200 'xx'

[wuzongjie]

都是用ADO連接控件!!