Posting from the Informix-list
tomasz_baron@banpol.pl wrote:
>How to combine into a single question something like this:
>
>select count(*) from TabA where ColA=X;
>select count(*) from TabA where ColA=Y;>
>
>
>Thanks for all answers
>
select ColA, count(*) from TabA where ColA in (X,Y)
group by ColA
This will return
ColA count
X (some number)
Y (another number)
carlos
Currently on hiatus from unemployment.
----------------------
Do you do Linux? :)
Get your FREE @linuxstart.com email address at: http://www.linuxstart.com