The syntax for the SQL UPDATE statement when updating one table with data from another table is: UPDATE table1 SET column1 = (SELECT expression1 ...
www.google.com.tw