日期:2014-05-18  浏览次数:20681 次

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
------解决方案--------------------
可以,加个别名吧