Page 1 of 1

Update Query using an inner join

Posted: Thu 04 Nov 2021 18:57
by redhat
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.

Re: Update Query using an inner join

Posted: Fri 05 Nov 2021 11:36
by alexa
This is not supported in dbForge.

Though, you can vote for the following suggestion on the UserVoice forum UserVoice

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.