Matthew,

Your "as" should be outside the parentheses because you want it as part of
the final query, not as part of the subquery.  The renaming won't carry
outside the subquery if you put it inside the parentheses.  Also, try using
double quotes instead of single quotes.  The following worked for me:

select db.pct_utilized,log.pct_utilized,(select count(*) from
volumes where access='READONLY') as "READONLY", (select count(*) from
volumes where access='UNAVAILABLE') as "UNAVAILABLE" from db,log

Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail