SOLVED: update query update from another table
Posted: Fri Feb 09, 2018 7:44 pm
Hi,
Can I run an query,
That update a table with a select from another table?
Can I run an query,
That update a table with a select from another table?
here is an example:
Code: Select all
UPDATE update_table AS a, source_table AS b SET a.update_column=b.source_table WHERE a.id=b.id;