Update Query using an inner join
Posted: Thu 04 Nov 2021 18:57
Hi-
I wanted to update a column in table1 using data from a column in table2.
But the query builder window won't allow more than one table for update queries.
If I convert a select query that uses an inner join on two tables to an update query, one of the tables disappears.
Is this limitation by design, or am I doing something incorrectly?
Thank you.
I wanted to update a column in table1 using data from a column in table2.
But the query builder window won't allow more than one table for update queries.
If I convert a select query that uses an inner join on two tables to an update query, one of the tables disappears.
Is this limitation by design, or am I doing something incorrectly?
Thank you.