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];
|