<div>
<div class="content wysiwyg-content">
I have three Oracle tables that share a common field. &nbsp;Table A contains all records. &nbsp;Tables B and C are index tables that contain a unique non-intersecting subset of records that together should equal all records in Tables A. &nbsp;Table A however contains additional orphaned records that no longer are indexed in either Tables B and C. &nbsp;How can I find the orphaned records in table A?
</div>
</div>


I have three Oracle tables that share a common field.  Table A contains all records.  Tables B and C are index tables that contain a unique non-intersecting subset of records that together should equal all records in Tables A.  Table A however contains additional orphaned records that no longer are indexed in either Tables B and C.  How can I find the orphaned records in table A?

Finding Orphaned Records In Oracle Table

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.