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 )