Hello everyone, I am going to share the query to
update a table using JOIN and without in SQL Server.
Table
of Contents.
1.
Query for update a table using INNER
JOIN.
2.
Query for update a table without
JOIN.
The query detail as given below.
Query for update a table using INNER JOIN. i.e.
UPDATE UR SET UR.IsDeleted = 1
FROM [DBO].[USERROLE] AS UR
INNER JOIN [DBO].[USERS] AS U ON UR.UserID = U.UserID
WHERE UR.UserID = 1001
AND U.UserID = 1001
Query for update a table without JOIN. i.e.
UPDATE U
SET U.ISDELETED=0
FROM [DBO].[USERROLE] AS U
WHERE U.USERID=1023
For more detail go to link.