The ability to specify from and join clauses for an Update Query is something very necessary. It is in SSMS. I go back and forth between SSMS and Query Builder for my SQL programming. And it was first mentioned as something that needed to be added to Query Builder in 2013.

Please push this to a higher priority. I think that people use other products because of this-- you just don't hear about it because they aren't going to bother adding it to this forum.

I notice that the first comment was some 2 years ago. Still not implemented and yes it's a major hole in what is otherwise a great product. I too might have to look at an alternative in my evaluation.

I believe a product like DBForge SQL Server should have this feature... it came to me as a major surprise that the possibility to update the database with joined tables in query builder was not standard feature.

This is a serious miss and defnitely a reason why we may consider another product in the future... unless Devart announces support for this like... Very soon?

multiple database support here would be a huge plus as well. code like this runs in SSMS but not in devart Query Builder.

UPDATE asmc.dbo.searchspringFeed

SET asmc.dbo.searchspringFeed.[Qty Uncommitted] = SixBit_BT.dbo.Inventory.QtyUncommitted , asmc.dbo.searchspringFeed.[Fixed Price] = SixBit_BT.dbo.Inventory.FixedPrice

FROM SixBit_BT.dbo.Inventory

WHERE asmc.dbo.searchspringFeed.[Item ID] = SixBit_BT.dbo.Inventory.ItemID