Hello, I am in need of producing a query that has two count fields in it... Something like:
select to_char(ts, 'MM/DD/YYYY') as "day", str, proc, (select count (*) as good from foobar where z != 0), (select count (*) as bad from foobar where z = 0) from foobar where str != 99999 group by str, day, proc order by str >From this query, the output should look something like this: day | str | proc | good | bad 09/10/2007 | 1 | xyz | 1 | 3 09/10/2007 | 1 | abc | 3 | 2 09/10/2007 | 2 | xyz | 3 | 5 09/10/2007 | 2 | abc | 1 | 2 I hope I have explained the situation... I appreciate the help... Thanks. -Jeff
