Hello!
Is there any non-functional difference between these two forms of Update?
WITH name AS ( SELECT )
UPDATE tbl SET ...
FROM name
WHERE tbl.id = name.id
and
UPDATE tbl SET ...
FROM ( WITH qry AS ( SELECT ) SELECT * FROM qry ) AS name
WHERE tbl.id = name.id
They both better give the same
On 4/13/15 8:12 PM, David G. Johnston wrote:
Hello!
Is there any non-functional difference between these two forms of Update?
WITH name AS ( SELECT )
UPDATE tbl SET ...
FROM name
WHERE tbl.id http://tbl.id = name.id http://name.id
and
UPDATE tbl SET ...
FROM ( WITH qry AS ( SELECT ) SELECT *