SqlServer不支持如下查询吗
select id from
(
SELECT id,name from tb_user
)
求解惑
------解决思路----------------------
--必须要加个别名
select id from
(
SELECT id,name from tb_user
) a
select id from
(
SELECT id,name from tb_user
)
--必须要加个别名
select id from
(
SELECT id,name from tb_user
) a