hallo,
Ik wil sql runnen en krijg geen result case else
(CASE WHEN INSTR(a.wrkref, ',', 1)=0 then
(select LISTAGG(subnum, ''',''') WITHIN GROUP(ORDER BY wrkref)subnum
from invdtl
where wrkref in ( a.wrkref ))--a.wrkref =W00003HA9X
--result = CTN2379828
else
(select LISTAGG(subnum, ''',''') WITHIN GROUP(ORDER BY wrkref)subnum
from invdtl
where wrkref in (a.wrkref)) --a.wrkref =W00003DRJJ','W00003DRJK
--result = NULL
end) as subnum
Ik wil sql runnen en krijg geen result case else
(CASE WHEN INSTR(a.wrkref, ',', 1)=0 then
(select LISTAGG(subnum, ''',''') WITHIN GROUP(ORDER BY wrkref)subnum
from invdtl
where wrkref in ( a.wrkref ))--a.wrkref =W00003HA9X
--result = CTN2379828
else
(select LISTAGG(subnum, ''',''') WITHIN GROUP(ORDER BY wrkref)subnum
from invdtl
where wrkref in (a.wrkref)) --a.wrkref =W00003DRJJ','W00003DRJK
--result = NULL
end) as subnum