﻿--select op.Title, sdi.* 
update sdi set sdi.Pro_ID_Unit = k.Pro_ID_Vahed
from StoreDocument SD
	INNER JOIN StoreDocumentItem sdi on sd.ID = sdi.SD_ID
	inner join OtherProperties op on sd.Pro_ID_DocType = op.ID
	inner join kala k on sdi.Kal_ID = k.ID
where sdi.Pro_ID_Unit <0