Wednesday, July 20, 2011

Can you use JOIN in UPDATE ?

YES.

e.g.
update
set
from
where

Remember the syntax :
UPDATE TableA
SET colname=TableB.colname ( or anything else)
FROM TableA, TableB
WHERE  <join condition>


Have a look at following links for more information :
SUMMARTIMELISTSENSUMMER2011.id >= #tempRSC.id and SUMMARTIMELISTSENSUMMER2011.id <= #tempRSC.laststoprowid
SUMMARTIMELISTSENSUMMER2011 ,#tempRSC
routename = #tempRSC.f33
SUMMARTIMELISTSENSUMMER2011

No comments:

Post a Comment

MCP 2025-11-25 vs. MCP 2026-07-28

A comparison of the major protocol changes introduced in the MCP 2026-07-28 specification. The following table co...