Skip to Content
0
Jun 26, 2018 at 11:03 AM

error: single-row query returns more than one row AMDP

3293 Views Last edit Jun 26, 2018 at 12:40 PM 5 rev

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