|
Posted by Chris.Cheney on 09/01/07 11:03
Erland Sommarskog <esquel@sommarskog.se> wrote in
news:Xns999E7C562A7ACYazorman@127.0.0.1:
> UPDATE tbl
> SET col = ...
> FROM tbl
> JOIN othertbl ...
IMHO it is also worth noting that the tbl immediately following the UPDATE
may be an alias so that one may write
UPDATE a
SET col = ...
FROM tbl a
....
(but the form UPDATE tbl a SET col = ... isn't permitted)
and this can avoid some confusion (to the human reader/writer - of course
the computer executes what was written, even if it isn't what the SQL
writer intended)
Navigation:
[Reply to this message]
|