querybuilder icon indicating copy to clipboard operation
querybuilder copied to clipboard

Added joins on CompileUpdateQuery for issue #637

Open brykneval opened this issue 3 years ago • 1 comments

Added joins on UPDATE query. Results as

UPDATE [Test1] 
SET [Test1].[Test1Id] = 1
, [Test1].[Test1Description] = 'Name2Value' 
FROM [Test1]\nLEFT JOIN [Test] ON [Test].[TestId] = [Test1].[Test1Id]

brykneval avatar Jan 10 '23 05:01 brykneval

This is not compatible with MySql and maybe with Oracle too

ahmad-moussawi avatar Jan 10 '23 15:01 ahmad-moussawi