心急如火!!馬上給分!!
有兩個表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'