SELECT SUBSTR(PARM_VALUE,INSTR(PARM_VALUE,'(')+1,INSTR(PARM_VALUE,')')-INSTR(PARM_VALUE,'(') - 1 ) FROM PARM_TABLE
is the query that is generating the values two rows of data.
xxxx,yyyy
zzzz
zzzz
But I am just using the same query as a sub query
SELECT CYCLE_ID,DIRECT_PAY,OVERRIDE_OPTIONS
FROM CYCLE_Table
WHERE CYCLE_ID IN (
SELECT SUBSTR(PARM_VALUE,INSTR(PARM_VALUE,'(')+1,INSTR(PARM_VALUE,')')- INSTR(PARM_VALUE,'(') - 1 ) FROM PARM_TABLE
)
FROM CYCLE_Table
WHERE CYCLE_ID IN (
SELECT SUBSTR(PARM_VALUE,INSTR(PARM_VALUE,'(')+1,INSTR(PARM_VALUE,')')- INSTR(PARM_VALUE,'(') - 1 ) FROM PARM_TABLE
)
This query just checks the direct_pay status and override_options status for the cycle ID's that are gererated by the sub query.
But here I am getting the status for those row ID's which have only one data within parantheses like (zzzz)
I am not getting the status for those row ID's which have more than one values like (xxxx,yyyy)
Also If I use all the ID's that are generated by the sub query (xxxx,yyyy,zzzz) manually instead of aub query I am getting the status for all the ID's.