In MySQL you should be able to do this:
\nUPDATE supplier JOIN customers ON customers.customer_id = supplier.supplier_id\nSET supplier_name = customer.name\n


In MSSQL you can do the same thing by using an UPDATE table FROM joined tables. I don't know if either way of doing this is strictly SQL standard legal.

Jay