Update Query using an inner join

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
redhat
Posts: 4
Joined: Thu 07 Nov 2013 20:04

Update Query using an inner join

Post by redhat » 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.

alexa

Re: Update Query using an inner join

Post by alexa » Fri 05 Nov 2021 11:36

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.

Post Reply