﻿update th set th.TH_ID = (select ID from TaxHeader t where t.Taxid = TH.irtaxid)
from TaxHeader th
	inner join Domain domStatus on th.Dom_ID_Status = domStatus.ID
	inner join Domain domSubject on th.Dom_ID_SubjectTax = domSubject.ID
	inner join Matter mat on th.Mat_ID = Mat.id
	inner join Karbar k on mat.CodeKarbar = k.ID
	inner join Tafsili taf on taf.ID = k.Taf_ID
where th.Dom_ID_SubjectTax <> 1554 and  len(ltrim(rtrim(isnull(th.Irtaxid,'')))) = 22 and TH_ID is null