search

sqlkata / querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
https://sqlkata.com
MIT License
3.08k stars 498 forks source link

Added joins on CompileUpdateQuery for issue #637 #656

Open brykneval opened 1 year ago

brykneval commented 1 year ago

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]
ahmad-moussawi commented 1 year ago

This is not compatible with MySql and maybe with Oracle too