Example of Update using Join

Update B2B.POdetails Set QtyOrdered=0,ModifiedBy=0,ModifiedOn=GetDate(),Remarks='Force Closed From Backend'
From
B2B.POHeader POH
Where
B2B.POdetails.OrgUnitCode=POH.OrgUnitCode And
B2B.POdetails.FinYear=POH.finyear And
B2B.POdetails.FinMonth=POH.FinMonth And
B2B.POdetails.POno=POH.POno And
POH.OrderNo=@OrderNo And (POH.POStatus='N' or POH.POStatus='E')