Subject | Sum, Union and Count |
---|---|
Author | Luis |
Post date | 2002-08-08T19:58:32Z |
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
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