有两个表A和B:
A B
--------------------------- -------------------------
ID TypeID_FK RecordDate TypeID TypeName
1 01 2006-12-18 01 类型1
2 01 2006-12-18 02 类型2
3 02 2006-12-18 03 类型3其中A.TypeID_FK是外键,与B.TypeID关联。现在想得到以下统计结果:count TypeName
-------------------
2 类型1
1 类型2
0 类型3用SQL
select count(*) as count,B.TypeName from A,B where TO_CHAR(A.RecordDate,'YYYY-MM-DD')='2006-12-28' and A.TypeID_FK=B.TypeID group by B.TypeName
查询的话,得到的结果只有:count TypeName
-------------------
2 类型1
1 类型2也就是说count为0的类型3不显示了,有办法解决否?
A B
--------------------------- -------------------------
ID TypeID_FK RecordDate TypeID TypeName
1 01 2006-12-18 01 类型1
2 01 2006-12-18 02 类型2
3 02 2006-12-18 03 类型3其中A.TypeID_FK是外键,与B.TypeID关联。现在想得到以下统计结果:count TypeName
-------------------
2 类型1
1 类型2
0 类型3用SQL
select count(*) as count,B.TypeName from A,B where TO_CHAR(A.RecordDate,'YYYY-MM-DD')='2006-12-28' and A.TypeID_FK=B.TypeID group by B.TypeName
查询的话,得到的结果只有:count TypeName
-------------------
2 类型1
1 类型2也就是说count为0的类型3不显示了,有办法解决否?
select count(a.*) as count,B.TypeName from A,B where TO_CHAR(A.RecordDate(+),'YYYY-MM-DD')='2006-12-28' and A.TypeID_FK(+)=B.TypeID group by B.TypeName