Sample Header Ad - 728x90

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