How to sql question

select sum((select count(*) from srv zt, z where zt.some_id = z.sid
union select count(*) from srv_arc yt, z where
yt.some_id = zsid))
from systables where tabid=1
# ^
# 284: A subquery has returned not exactly one row.
#


Any suggestions on how to get this into the singleton select pls.

Its part of a huge support type corruption detction statement, so the
" into temp " is not an option.

Table z has a couple of integers as a list of jobs to investigate.

select (select count(*) from srv zt, z where zt.some_id = z.sid) + (select
count(*) from srv_arc yt, z where
yt.some_id = zsid) as total
from systables where tabid = 1;

Art


On Mon, Aug 18, 2008 at 8:09 AM, ian wrote:

> select sum((select count(*) from srv zt, z where zt.some_id = z.sid
> union select count(*) from srv_arc yt, z where
> yt.some_id = zsid))
> from systables where tabid=1
> # ^
> # 284: A subquery has returned not exactly one row.
> #
>
>
> Any suggestions on how to get this into the singleton select pls.
>
> Its part of a huge support type corruption detction statement, so the
> " into temp " is not an option.
>
> Table z has a couple of integers as a list of jobs to investigate.
> _______________________________________________
> Informix-list mailing list
> Informix-list-at-iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>



--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art-at-iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.

Thanks Art
Talk about missing the bleedin obvious !