Combining 2 queries 2

[Zen216]

Hello All,
I am an extreme newbie in SQL so sorry in advance if this is real easy..

I have a couple of simple queries to count the total number of clients in a certain state with sertain status, but I need to get total of more than one status..

ie.
SELECT COUNT(*) as total
WHERE state = 'PA' and status = 'A'

returns 50


SELECT COUNT(*) as total
WHERE state = 'PA' and status = 'B'

returns 150,

there are 4 main statuses,, how would I combine the two top querires to give me the total of all accounts with a status A or B? (total would be 200)

Thanks Again..

(SQL 2000 on win 2003 std)

 

[Zen216]

Duh.. sorry,, I forgot part of the queirie...lol

SELECT COUNT(*) as total
FROM CUSTOMER
WHERE state = 'PA' and status = 'B'

 

[jbenson001]

Select Status, Count(*) as Total
Where State = 'PA'
Group By Status

 

[bborissov]

SELECT COUNT(*) as total
WHERE state = 'PA' and 
      status IN ('A', 'B')

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[Zen216]

Jbenson,

Thanks so much, that has helped emensly.

the only problem now for me is, that there is about 40 statusses, and I need to get a total of 2 or 3.. this gives mee all of the statusses and the total of each,,, and I can add the 2 or 3 that I am looking for together,, however I was hoping to get it in one query...

Thanks again

 

[Zen216]

bborissov

Thank You VERY MUCH!!!! that is exactly whaty I was looking for

 

[jbenson001]

Then Borislav's solution should work for you