求一数据库语句，在线等。

[lxpandsq]

现在，在同一张表里面有两个字段。
如下：

表名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

[wolf863292]

看不明白......

select name as name,count(*) as id 
from test 
  where id='1'
    and id>'3' 
  group by name

不行么？

[wolf863292]

额，不是and，是or

select name as name,count(*) as id 
from test 
  where id='1'
    or id>'3' 
  group by name

[lxpandsq]

[Quote=引用 2 楼 的回复:]
额，不是and，是or

SQL code


select name as name,count(*) as id
from test
where id='1'
or id>'3'
group by name

name id

A 3

我要的效果是，
name IDA IDB

A 1 2


[/Quote]

不是的，你这样出来的结果，是

[lxpandsq]

name id

A 3

我要的效果是，
name IDA IDB

A 1 2

[WilliamMoore]

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)) tb2
where tb1.name = tb2.name;

[WilliamMoore]

咕~~(╯﹏╰)b 别名可以自己加

select tb1.name as name,tb1.id as idA,tb2.id as idB 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)) tb2
where tb1.name = tb2.name;

[Quote=引用 4 楼 的回复:]

name id

A 3

我要的效果是，
name IDA IDB

A 1 2
[/Quote]

[lxpandsq]

[Quote=引用 5 楼 的回复:]
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)) tb2
wh……
[/Quote]

哈哈，不错，搞定，多谢，结贴给分；