以下语句好像是where子句有一定问题,可能是位置问题,请高手指正:
update hkb set shksj=jkb.hsj,sqje=jkb.qje where hkb.cid=@cid from hkb join jkb on hkb.cid=jkb.cid
update hkb set shksj=jkb.hsj,sqje=jkb.qje where hkb.cid=@cid from hkb join jkb on hkb.cid=jkb.cid
update hkb set shksj=jkb.hsj,sqje=jkb.qje from hkb join jkb on hkb.cid=jkb.cid where hkb.cid=@cid