hi all,
iam trying to use coalesce function in IN condition
et_res = select carrid from scarr as a
where carrid in(
select
coalesce( (select carrid from sflight),
(select carrid from scarr))
as carrid FROM scarr);
please help me solve this issue