sql语句
写法一:
select id, name from
( select 1 as id, 'new' as name
UNION select 2 as id, 'dealing' as name
UNION select 3 as id, 'shipped' as name
) t--加个别名,子查询结果作为表要加别名
解释:
select * from
(
selelct *****************************************
) as T
子查询相对最外层的select ,少个表名.把括号里的子查询起个别名。
写法二:
select [id], [name] from
(select 1 as [id], 'new' as [name]
UNION
select 2 as [id], 'dealing' as [name]
UNION
select 3 as [id], 'shipped' as [name]) as t
解释:
SQL语言提供一些保留关键字,属于数据库自身要用的。在建立表时,如果表名以及数据字段名用到关键字,那么在以后调用时就需要加上[]括起来。