27,580
社区成员
发帖
与我相关
我的任务
分享
UPDATE e
SET def16=ISNULL(d.depart_name,def16),def17=ISNULL(d2.depart_name,def17),def18=ISNULL(d3.depart_name,def18)
FROM employee AS e
INNER JOIN inserted AS i ON e.employeeid=i.employeeid --唯一
LEFT JOIN departs AS d ON d.depart_id=LEFT(a.depart_id,3)
LEFT JOIN departs AS d2 ON d2.depart_id=LEFT(a.depart_id,5)
LEFT JOIN departs AS d3 ON d3.depart_id=LEFT(a.depart_id,7)
WHERE def16 IS NULL OR def17 is NULL OR def18 is NULL