不好意思,两个表中的字段名称有可能不一样,即
TB1:
ID Field1 Field2 Field3
1 a d gTB2:
T_ID Field4 Field5 Field6
2 b e h结果要为
T_ID Field1 Field2 Field3
2 a d g
TB1:
ID Field1 Field2 Field3
1 a d gTB2:
T_ID Field4 Field5 Field6
2 b e h结果要为
T_ID Field1 Field2 Field3
2 a d g
update TB2 set
Field1=(select Field1 from TB1 where id=1),
Field2=(select Field2 from TB1 where id=1),
Field3=(select Field3 from TB1 where id=1)
where T_ID=2
Field4=(select Field1 from TB1 where id=1),
Field5=(select Field2 from TB1 where id=1),
Field6=(select Field3 from TB1 where id=1)
where T_ID=2
Field1 = TB1.Field1 from TB1,TB2 where TB1.Field1 = TB2.Field1 没测试。 楼主做个参考吧。
SELECT serialno,sdate,posno,cshcode,total,change/*源表字段*/
FROM total/*源表*/