Marbe this helps.
UPDATE LnkCustProduct SET LnkCustProduct.CustVid = hc.CustVid
FROM SuspectRecords SR inner join hubCustomer hc on SR.SourceParentGID=hc.CustSourceGid
INNER JOIN hubProductSale HPS ON SR.SourceChildGid=HPS.ProductSourceGid AND
SR.SourceParentGID=HPS.CustSourceGid
INNER JOIN LnkCustProduct LCP ON HPS.ProductSaleVid=LCP.ProductSaleVid
DELETE SuspectRecords WHERE EXISTS(SELECT CustVid FROM HubCustomer HC WHERE SuspectRecords.SourceParentGID=hc.CustSourceGid )