yes, but without giving actual table structure and data i would be only
here is one example on northwind database.
select (select count(*) from customers) 'these are total counts of table',
(select count(*) from customers where customerid ='ALFKI') 'these are counts
for customerid alfki'
"Ben" <Benrfscliffhanger.com> wrote in message
> Is it possibel for me to have a query such that I want to
> return 2 values , ir, the count of entries in teh table
> and the count of entries satisfying certain criteria.?
> This must be returned in teh ...