Hi
You could update on driven table but in other way,
You were trying :
Update T SET Id=0 FROM (SELECT * FROM tt1) AS T
but you could use this as follow , will work fine :
update t set id =0
from tt1 as T where ...
You could add you where clause too, you could do that with complex driven tables too.
Mnaouar Ben Khelifa