Hi
you can use nested query and
DECODE() function for solve this problem, like this :
select i.ISREQUEST,
i.ISREQUESTTYPEID,
i.ISREQUESTDATE,
decode((SELECT count(*)
from asas.tbl_isinterrogators s
where s.isrequest = i.ISREQUEST
and s.persontype = 1),
0,
'FALSE',
'TRUE') as isinterrogators
from tbl_isrequest i
where i.status = 3
OR i.status = 2
and i.igapppersonmid = 787670;