• I think the OP wants to update products where suppliers for that product > 2. So, should the rows be filtered by COUNT(1) > 2?

    --Ramesh