I need to sum the field *COST* in this query where data in *STATUS* is
equal to "HELD" and "OPEN", so I will have 2 totals passed below and do
not know where to begin .

All information is in 1 table.


Original query

select distinct(Company_name), account, City, State from table where
number = 100


Failed miserably 

select distinct(Company_name) , account, City, State, sum(cost) from
table where number= 100 and status="HELD" 


I need to be able to pull the $$ amount totals by company name for
status equal to HELD and OPEN .




 Company A      OPEN               HELD

     1233            100.00                50.00


Any suggestion would be appreciated.


Larry Sandwick

Sarreid, Ltd.

Network/System Administrator

phone: (252) 291-1414 x223

fax      : (252) 237-1592


Reply via email to