说明:sql语句美化器,格式化sql语句
update a
set a.ID = b.ID,
Name = b.Name
from Table1 a
inner join
(
select ID,
Name
from Table2
where Active 0
and Current 0
) b on a.ownerid = b.ownerid and a.type = b.type and b.version = '87.1' and a.Name is NU
<lizhenyu1021> 上传 | 大小:28kb