Freelance Project Requests Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net

SQL Server Update Select Inner Join Sample



Example SQL Update Command in SQL Server


USE [codedocu_de]



UPDATE [dbo].[tbl_Articles]

  SET tbl_Articles.HtmlContent = tblWeb_Details.Text0

  FROM tbl_Articles INNER JOIN tblWeb_Details ON tbl_Articles.IDArticle = tblWeb_Details.IDDetail;





On  SQL Server:


In Access, the syntax is similar. However, you have to look at the order of the syntax differently here:


UPDATE dbo_tblWeb_Details INNER JOIN dbo_tbl_Articles ON dbo_tblWeb_Details.IDDetail = dbo_tbl_Articles.IDArticle

SET dbo_tbl_Articles.HtmlContent = [dbo_tblWeb_Details]![Text0];









Contact for Jobs, Project Requests: