SQL Server Update Select Inner Join Sample
Beispiel SQL Update Command in SQL Server
USE [codedocu_de] GO
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; GO
|
Im SQL Server:
In Access lautet die Syntax Γ€hnlich. Allerdings muss man hier die Reihenfolge der Syntax anders betrachten:
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]; |