SQL: UPDATE Statement - TechOnTheNet.com
Example - Update table with data from another table Let's look at an UPDATE example that shows how to update a table with data from another table. UPDATE customers SET c_details = (SELECT contract_date FROM suppliers WHERE ......