一个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)

[SQL77]

select id, name from 
 (
select 1 as id, 'new' as name  
 UNION  ALL
select 2 as id, 'dealing' as name  
UNION  ALL
select 3 as id, 'shipped' as name) t

[新枯木逢春]

C:\Documents and Settings\All Users\Documents\My Pictures\範例圖片\200809281036227452[1].jpg

[weinideai]

[Quote=引用 17 楼 tsailer 的回复:]
SQL codeselect [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


报错
訊息 207，層級 16，狀態 1，行 2
Invalid column name '1'.
訊息 207，層級 16，狀態 1，行 4
Invalid column name '2'.
訊息 207，層級 16，狀態 1，行 6
Invalid column name '3'.
是不是啊？
[/Quote]

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 

[linguojin11]

bang定

[等不到来世]

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

[jiangshun]

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

[--小F--]

--差一点东西
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

[新枯木逢春]

为什么我的

select * from tas
 (select 1 as id, 'new' as name  UNION  select 2 as id, 'dealing' as name  UNION  select 3 as id, 'shipped' as name) as tas

不行

大侠们的t什么意思啊？

[--小F--]

[Quote=引用 4 楼 tsailer 的回复:]
为什么我的
SQL codeselect * from tas
(select 1 as id, 'new' as name UNION select 2 as id, 'dealing' as name UNION select 3 as id, 'shipped' as name) as tas

不行

大侠们的t什么意思啊？
[/Quote]

一个别名而已

[Small_Four]

加个别名就好了

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

[moonshineidolon]

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

[等不到来世]

[Quote=引用 4 楼 tsailer 的回复:]
为什么我的
SQL codeselect * from tas
(select 1 as id, 'new' as name UNION select 2 as id, 'dealing' as name UNION select 3 as id, 'shipped' as name) as tas

不行

大侠们的t什么意思啊？
[/Quote]

select * 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 tas

[等不到来世]

as可以省略。

[htl258_Tony]

[Quote=引用 4 楼 tsailer 的回复:]
为什么我的
SQL codeselect * from tas
(select 1 as id, 'new' as name UNION select 2 as id, 'dealing' as name UNION select 3 as id, 'shipped' as name) as tas

不行

大侠们的t什么意思啊？
[/Quote]
t是别名,
select * from --tas楼主多了这个,把它去掉就行了.
(select 1 as id, 'new' as name UNION select 2 as id, 'dealing' as name UNION select 3 as id, 'shipped' as name) as tas

[新枯木逢春]

明白，多谢各位

[cab1225]

[Quote=引用 3 楼 fredrickhu 的回复:]
SQL code--差一点东西
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
[/Quote]

这个不错，试一下，应该 对的！

[JonasFeng]

表别名，楼主没加。
所以出错的。

[feixianxxx]

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--加个别名就好了，子查询结果作为表 要加别名

[bennyyyyy]

缺个别名

[jinlingoo1]

select * from
(
selelct *****************************************
) as T
你的查询,相对最外层的select 来说少了个表名.把括号里的子查询起个别名就好了.