select count(*) as total from clients
where (clientes.id=10) OR (clientes.id=11)

HTH,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com

> -----Original Message-----
> From: news@... [mailto:news@...]On Behalf Of Luis
> Sent: Thursday, August 08, 2002 9:59 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Sum, Union and Count
>
>
> How to do this:
>
> Select count(*) Total from clients where clientes.id=10
> Union
> Select count(*) Total from clients where clientes.id=11
>
> It will return
>
> Total
> -----
> 300
> 200
>
> Want to return
> Total
> -----
> 500
>
> Thanks
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>