Simple SQL Update with Join and Where Exists
UPDATE Part_Master SET RECVEN_01 = VENID_10from Part_Master as P INNER join Order_Master as O ON P.PRTNUM_01 = O.PRTNUM_10WHERE EXISTS(SELECT PRTNUM_10, VENID_10FROM Part_Master as P join Order_Master as O ON P.PRTNUM_01 = O.PRTNUM_10WHERE TYPE_01 = ‘B’ OR TYPE_01 = ‘O’GROUP BY PRTNUM_10, VENID_10)