update里的from后面能跟子查询么？
update table1
set
name = t.name
age = t.age
from table2 t ----此处能用子查询么？如：from(select * from table2 where ......)
where id = t.id
[解决办法]
update table1
set
name = t.name,
age = t.age
from
(select * from table2 where ......) t
where
table1.id = t.id
[解决办法]
可以，加个别名吧
