no rows selected vs.

would anybody can solve this issue for me please?

i am counting number with the following query:

select count(rowid)
into zeronoaredi
from emp1
where
empno NOT in
(select empno from emp2

 where to_char(date_posted,'MON')=to_char(sysdate,'MON') )
and
empno NOT in
(select empno from emp3

 where to_char(date_posted,'MON')=to_char(sysdate,'MON') )

if NO ROWS SELECT is returned from the emp3 table, business logic still allowable(to take NO ROWS SELECT as zero), how can i still have the result to be selected into the varialble zeronoaredi, instead of being bounced to the exeception?

thanx.

hwg Received on Mon Feb 11 2002 - 00:21:53 CET