select * from (union)后面可以加where条件吗?

cyn_sg

问题如下
SELECT *, '02' as Div FROM `\\secc347\Season 1\sec02`.[Season 1$B8:AA176]  where [Season 1$B8:AA176].dept >0 union all
SELECT *, '02' as Div FROM `\\secc347\Season 1\sec06`.[Season 1$B8:AA176] where [Season 1$B8:AA176].dept >0 union all
SELECT *, '02' as Div FROM `\\secc347\Season 1\sec08`.[Season 1$B8:AA176] where [Season 1$B8:AA176].dept >0 union all
SELECT *, '02' as Div FROM `\\secc347\Season 1\sec11`.[Season 1$B8:AA176] where [Season 1$B8:AA176].dept >0
是我用做database的query, 现在我需要过滤些信息, 条件是表里的field [country]="china*" or "Korea*"
想这样写
select * from (SELECT *, '02' as Div FROM `\\secc347\Season 1\sec02`.[Season 1$B8:AA176]  where [Season 1$B8:AA176].dept >0 union all
SELECT *, '02' as Div FROM `\\secc347\Season 1\sec06`.[Season 1$B8:AA176] where [Season 1$B8:AA176].dept >0 union all
SELECT *, '02' as Div FROM `\\secc347\Season 1\sec08`.[Season 1$B8:AA176] where [Season 1$B8:AA176].dept >0 union all
SELECT *, '02' as Div FROM `\\secc347\Season 1\sec11`.[Season 1$B8:AA176] where [Season 1$B8:AA176].dept >0) where country="china*" or "country ="korea*"
Excel报错. 我猜想是缺少这个union query做为表的名字, 因为不加where条件是可以用的.
请教这个应该怎么改?

sgrshh29

"select a.* from (SELECT *, '02' as Div FROM `\\secc347\Season 1\sec02`.[Season 1$B8:AA176]  where [Season 1$B8:AA176].dept >0 union all
SELECT *, '02' as Div FROM `\\secc347\Season 1\sec06`.[Season 1$B8:AA176] where [Season 1$B8:AA176].dept >0 union all
SELECT *, '02' as Div FROM `\\secc347\Season 1\sec08`.[Season 1$B8:AA176] where [Season 1$B8:AA176].dept >0 union all
SELECT *, '02' as Div FROM `\\secc347\Season 1\sec11`.[Season 1$B8:AA176] where [Season 1$B8:AA176].dept >0 ) as a

where a.country like 'china*' or "a.country  like 'korea*'"

cyn_sg

thanks
成功了一半, 但是like 'Korea*' 用*通配符似乎不起作用

Scarlett_88

在ACCESS和excel中用通配符是不同的
ACCESS中用“*” excel和SQL server中用“%”

cyn_sg

是的, 查到了, 谢谢

还有名字的话, 不能用"Korea% ", 而是'Korea%'.

有人能解释下 ``, 这个符号和' ' (单引号)都是在什么时候用吗?