这个sql语句该怎么写？

[qinamao]

已知表a中的有字段 a1,a2,a3,a4 及其内容
如何用一句话表示
“将表a中的a2='A' 的记录总数和a3='B' 的记录总数分别以字段名a2n、a3n存到新表c中”？

注意：
1、c 原来并不存在
2、a 中除“a2”“a3”外，还有其他字段

[JYCheng]

select sum(a2n) as a2n, sum(a3n) as a3n
into C
From (
select count(*) as a2n, 0 as a3n from A where a2='A'
union all
select 0 as a2n, count(*) as a3n from A where a3='B'
) temp

[qinamao]

请教 JYCheng(Cheng程氏) ：

From (
select count(*) as a2n, 0 as a3n from A where a2='A'
union all
select 0 as a2n, count(*) as a3n from A where a3='B'
) temp
这是什么意思？

[muddledman]

看来只能用存储过程实现了！

[老马2008]

是一个联机视图，你用的什么数据库？？

[老马2008]

//如果是Oracle
create table c
as
select sum(case when a2='A' then 1 else 0 end) as a2n,
sum(case when a3='B' then 1 else 0 end) as a3n
from a;

[lin_x_gang]

select t1.a2n, t2.a3n
into C
From (
select count(*) as a2n from A where a2='A')
t1,
(select count(*) as a3n from A where a3='B'
) t2
我不知道 'into C'能不能创建一个新表 C ，请指教。
对 JYCheng(Cheng程氏) 的一点修改。

[gangganghao]

select (select count(*) from a where a2='A') as a2n,(select count(*) from a where a3='B') as a3n into c

[老马2008]

对于MS SQL Server，select .... into 新表，是可以创建一个表。