现在，在同一张表里面有两个字段。
如下：
表名test
id name
1 A
2 B
3 A
4 C
5 A
select name as name,count(*) as id from test where id='1' group by name
select name as name,count(*) as id from test where id>'3' group by name
就会有两个结果，我希望，能把这两句话组合，变成结果为:
name ida ida
A 1 2
------解决方案--------------------------------------------------------
- SQL code
select * from (select name as name,count(*) as id from test where id='1' group by name) tb1, (select name as name,count(*) as id from test where id>'3' group by name)) tb2where tb1.name = tb2.name;