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