批量更改damagecomplete维修单位

UPDATE DamageComplete 
SET DamageComplete.DAMUNITNAME = (
SELECT
	DAMUNIT.NAME 
FROM
	damage d
	LEFT JOIN DamDaily ON d.DAMCODE = DamDaily.CODE 
	LEFT JOIN DAMUNIT ON DamDaily.UNIT =  DAMUNIT.CODE
WHERE
	d.id = DamageComplete.pid 
	)
	where DamageComplete.DAMUNITNAME is null
	
select * from 	DamageComplete	where DamageComplete.DAMUNITNAME is null
select * from 	Damage	where Damage.DAMUNITNAME is null
select * from 	Damage	where Damage.DAMCODE is null