<div>
Your question is not clear. &nbsp;Do you have multiple tables having OP_ID column?<br />
Can you provide more data and table structures?<br />

</div>


Your question is not clear.  Do you have multiple tables having OP_ID column?
Can you provide more data and table structures?


<div>
Thanks, this got me going in the right direction as part of a larger query I was building.
</div>


Thanks, this got me going in the right direction as part of a larger query I was building.

<div>
<div class="content wysiwyg-content">
I have a table that stores and OP_ORG_ID, OP_ID and ORG_ID associated with each OP_ID.<br />
<br />
An example would be like<br />
OP_ORG_ID, OP_ID, ORG_ID<br />
114, 12345, 10<br />
115, 12345, 40<br />
<br />
I want to be able to query the table and find all instances where an OP_ID has both ORG_ID 10 and 40 associated to it
</div>
</div>


I have a table that stores and OP_ORG_ID, OP_ID and ORG_ID associated with each OP_ID.

An example would be like
OP_ORG_ID, OP_ID, ORG_ID
114, 12345, 10
115, 12345, 40

I want to be able to query the table and find all instances where an OP_ID has both ORG_ID 10 and 40 associated to it

Find matching records

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.