I have a table with recordnumber, goodparts, badparts.

I need to know how many records there are for each goodparts and badparts.

Right now I run one query for each.

Select Count(recordnumber) As r1 From myTable Where goodparts > 0
Select Count(recordnumber) As r1 From myTable Where badparts > 0

How can I combine these two querys together to try and save processing time.

The SPT table I am accessing is db2.