L
libaoliang
Unregistered / Unconfirmed
GUEST, unregistred user!
我用delphi5.0+paradox+BDE 数据库开发了一个应用系统,数据更新的query1.sql 该
如何写?
我实验的以下几种写法都不对,(sql)
1: update cpk0 a set a.xs=88,a.zb0=88,a.zb1=88,a.zb2=88,a.zb3=88 from cpk b where a.cpmc=b.cpmc
2: update a set a.xs=88,a.zb0=88,a.zb1=88,a.zb2=88,a.zb3=88 from cpk0 a ,cpk b where a.cpmc=b.cpmc
3: update cpk0 a,cpk b set a.xs=88,a.zb0=88,a.zb1=88,a.zb2=88,a.zb3=88 where a.cpmc=b.cpmc
如何写?
我实验的以下几种写法都不对,(sql)
1: update cpk0 a set a.xs=88,a.zb0=88,a.zb1=88,a.zb2=88,a.zb3=88 from cpk b where a.cpmc=b.cpmc
2: update a set a.xs=88,a.zb0=88,a.zb1=88,a.zb2=88,a.zb3=88 from cpk0 a ,cpk b where a.cpmc=b.cpmc
3: update cpk0 a,cpk b set a.xs=88,a.zb0=88,a.zb1=88,a.zb2=88,a.zb3=88 where a.cpmc=b.cpmc