Re: SQL Question

Posted in 2000

Sujit.Pal@bankofamerica.com — Tue, 06 Jun 2000 08:44:00 -0700 — source: Informix-list mailing list archive (1991-1998)

Tomasz How about select (select count(*) from TabA where ColA=X), (select count(*) from TabA where ColA=Y) from systables where tabid = 1; HTH Sujit Tomasz Baron <tomasz_baron@banpol.pl> on 06/06/2000 01:11:19 AM Please respond to Tomasz Baron <tomasz_baron@banpol.pl> To: informix-list@iiug.org cc: Subject: SQL Question 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