Page 1 of 1
SOLVED: update query update from another table
Posted: Fri Feb 09, 2018 7:44 pm
by mister_v
Hi,
Can I run an query,
That update a table with a select from another table?
Re: update query update from another table
Posted: Fri Feb 09, 2018 9:52 pm
by chris
Yes, you can with update:
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;
Re: update query update from another table
Posted: Thu Nov 01, 2018 12:23 pm
by mister_v
thanks.