能不能在用union合并的两张表中进行select和group by查询

[xon]

能不能在用union合并的两张表中进行select和group by查询

[warning]

可以
select *
from (select a from table1 union select b from table2) as table3

[studyfor]

楼上的哥们，你写的这句话在sybase中执行不了！！！

xon：好像不行，得用临时表了。

select a into table3 from table1
insert into table3
select b from table2

select a from table3 group by a

[great2000]

上面的做法在sybase 11.5中也还是不行
请问上面的是在哪个版本下试过的

[htemb]

要这样写
select table3.*
from (select a from table1 union select b from table2) as table3

[gao]

就这样写
select a from table1 union select b from table2