SQL Update with WHERE EXISTS

This is for when you need to update multiple records based on values in another table.

I got my info here.

Example:

UPDATE suppliers
SET supplier_name =	( SELECT customers.nameFROM customers WHERE customers.customer_id = suppliers.supplier_id)
	WHERE EXISTS ( SELECT customers.name FROM customers WHERE customers.customer_id = suppliers.supplier_id);

Advertisement