YES.
e.g.
update
set
from
Remember the syntax :
UPDATE TableA
SET colname=TableB.colname ( or anything else)
FROM TableA, TableB
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