﻿--select k.Pro_ID_Vahed, bd.*
update bd set bd.Pro_ID_Unit = k.Pro_ID_Vahed
from Bargeh bar 
	inner join BargehDetail bd on bar.ID = bd.Bar_ID
	inner join kala k on bd.Kal_ID = k.ID
where
	bar.Dom_ID_Noe in (792,791 /*اضافات و کسورات انبار*/) and bd.Pro_ID_Unit <= 0
