Oracle Loop through values from one table and join with another table
0
votes
1
answer
169
views
I have a table (
table1
) with fields package_id
and contract_id
.
Data in table 1 is like that 1 package_id
can have 1 or more contract_id
associated with it.
I have another table (table2
) with contract_id
and status
. status can be ('active'
or 'dead'
)
I need to find the package_id
which doesn't have any contract_id
associated with it which is 'ACTIVE'
or in other words I need to find package_id
which has all contract_id
associated with it in 'DEAD'
state.
Please help.
Asked by user174676
(1 rep)
Mar 15, 2019, 01:35 AM
Last activity: Jul 4, 2025, 09:05 AM
Last activity: Jul 4, 2025, 09:05 AM