SOLVED: update query update from another table

[mister_v]

Hi,

Can I run an query,
That update a table with a select from another table?

[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;

[mister_v]

thanks.