现有表A和表B,两个表中的字段一模一样(共50个字段),假设表A中已存在一条数据(50个字段中全部有数据),而表B中只存在两个数据(bindid和jc,其中bindid是这条数据的唯一标识) ,现我想将表A的数据全部update到表B中,请问SQL语句该怎么写?
(我用的是sql server)
表A
表B
下面是我的SQL语句:
update 表A SET (CWBM, ZWMC, SXDM, YWMC, JSBZ, GJCS, TYDNR, CZ, LXDH,
DZYJ, GSWZ, GJZ, HGBM, FJSM, BCODE, HYCZ, KYCZ, FKQX, FPTT, YWY, HZLX, HZXZ, TBZY,
THDM, YFDM, FTYHSM, XXK, DZ, YB, CKLX, PTDL, CGSDL, HXDL, ZJDL1, JJDL, ZJDL2,
DLCGS, CKDZ, KHLX, FKQX2, FKQX3, TQQX2, TQQX, TBZY2, DZ1, DZ2, GSLX1, GSLX2, GSLX3,
GSLX4, GSLX5, GSLX6, GSLX7, WTDW, SPQK)=(select CWBM, ZWMC, SXDM, YWMC, JSBZ,
GJCS, TYDNR, CZ, LXDH, DZYJ, GSWZ, GJZ, HGBM, FJSM, BCODE, HYCZ, KYCZ, FKQX,
FPTT, YWY, HZLX, HZXZ, TBZY, THDM, YFDM, FTYHSM, XXK, DZ, YB, CKLX, PTDL, CGSDL,
HXDL, ZJDL1, JJDL, ZJDL2, DLCGS, CKDZ, KHLX, FKQX2, FKQX3, TQQX2, TQQX, TBZY2,
DZ1, DZ2, GSLX1, GSLX2, GSLX3, GSLX4, GSLX5, GSLX6, GSLX7, WTDW, SPQK from
表B where jc= 'h') where bindid ='11234'
请大神帮忙!!