oracle数据库问题！十万火急

[name_luolei]

主表 A 有字段 aId aTime(创建时间) aNmae(名称)
子表 B 有字段 bId aId(外键) btype(类型:1,2,3,4,5) bDate(修改时间)

查询列表
名称 类型 总数(类型) 总数（类型：时间为空的）

怎么查 按名称，类型分组，

[希望对你有帮助]

select ...... from A,B.......
group by aName.......

[music_mouse]

select 名称，类型 from A a,B b
where a.aId=b.aId
group by a.aName,b.btype;

[氧气网航]

select 名称，类型
inner join B b on a.aId=b.aId
group by a.aName,b.btype;
这样咯

[qybao]

时间为空是A的aTime为空，还是B的bDate为空？

select a.aName, b.btype, c.all_type, d.no_use_type
  from A a, B b,
       (select aId, count(distinct btype) from B group by aId) c,\
       (select aId, count(distinct btype) from B where bDate is null group by aId) d
 where a.aId = b.aId
   and a.aId = c.aId
   and a.aId = d.aId
 order by a.aName

[qybao]

忘了别名了

(select aId, count(distinct btype) as all_type from B group by aId) c
(select aId, count(distinct btype) as no_use_type from B where bDate is null group by aId) d