update T2 set T2.Name = T1.Name from T1 where T1.id = T2.id
我现在要用一张表的某个字段值去更新别一张表某个字段值(按关键字连接),如何实现,语句该怎么写??请高手指点。 update A set A.columnname=b.columnname from table1 A,table2 B where A.columnname1=B.columnname1
这样好象会把主键不相等的记录的更新字段值置为空,这不是我想要的结果(主键不相等的字段值保持原值)update A set A.columnname=b.columnname from table1 A,table2 B where A.columnname1=B.columnname1 and A.columnname in (select A.columnname from table1 C,table2 D where A.columnname1=B.columnname1)
update A set A.columnname=b.columnname from table1 A,table2 B where A.columnname1=B.columnname1 and A.columnname in (select A.columnname from table1 C,table2 D where C.columnname1=D.columnname1)
update A set A.columnname=b.columnname
from table1 A,table2 B
where A.columnname1=B.columnname1
from table1 A,table2 B
where A.columnname1=B.columnname1 and A.columnname in
(select A.columnname from table1 C,table2 D where A.columnname1=B.columnname1)
from table1 A,table2 B
where A.columnname1=B.columnname1 and A.columnname in
(select A.columnname from table1 C,table2 D where C.columnname1=D.columnname1)