Two Where clauses? [message #7407] |
Wed, 11 June 2003 17:02 |
Ted
Messages: 9 Registered: June 2002
|
Junior Member |
|
|
I need a result set that combines two where clauses into the output.
This query:
select entered_by, count(Dispute_num) as Submitted, TO_CHAR(null) as Researched from DISPUTE_DETAIL where BROC_USER is null group by entered_by order by count(Dispute_num) desc
produces:
entered_by Submitted Researched
A | 21 |
B | 15 |
C | 7 |
and
select entered_by, TO_CHAR(null) as Submitted, count(Dispute_num) as Researched from DISPUTE_DETAIL where BROC_USER is not null group by entered_by order by count(Dispute_num) desc
Produces
entered_by Submitted Researched
A | | 4
C | | 6
What I want is to combine the two to get results like.
entered_by Submitted Researched
A | 21 | 4
B | 15 | 0
C | 7 | 6
I think I need a Union All but I can't get it to work. Any help is MUCH appreciated!
-Ted
|
|
|
Re: Two Where clauses? [message #7408 is a reply to message #7407] |
Wed, 11 June 2003 17:26 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
select entered_by,
count(decode(broc_user, null, dispute_num, null)) submitted,
count(decode(broc_user, null, null, dispute_num)) researched
from dispute_detail
group by entered_by
order by count(decode(broc_user, null, dispute_num, null)) desc;
|
|
|