UPDATE supplier  \nSET supplier_name = COALESCE(\n  ( SELECT customer.name \n  FROM customers \n  WHERE customers.customer_id = supplier.supplier_id) ,\n  supplier_name )