title: Cross Referencing MASTER Table with SUB TABLES in ORACLE SQL Developer
body: <p>I farly new to Oracle SQL Developer and I have an idea that I would like to attempt, but I am not sure how it might be possible (and this just might be a silly question anyways)</p>
  
  <p>Here are the facts of the case:</p>
  
  <ul>
  <li>I have a schema in oracle that contains a number of tables. Around 100 or so.</li>
  <li>Within those 100 tables about 20 of them are what we call 'EVENT TABLES' which log various types of EVENTS that happen on the database. Each EVENT is unique.</li>
  <li>19 tables are sub category EVENT tables. Bascially, tables that are categorized by type. (i.e. an event table for changes in CLIENT CONTACT INFORMATION, another event table for changes in LAND OWNERSHIP, another event table for PAYMENT INFORMATION, etc)</li>
  <li>There is one EVENT table that is the MASTER TABLE, which contains ALL events, regardless of type. This table is loaded with events from the 19 sub category tables. If an event is logged into one particular sub table, it is logged in the MASTER TABLE as well</li>
  <li>All tables have a column named 'EVENT_NUMBER_ID' which is a unique number logged against the event that took place. This column is the join column between the 19 sub category tables and the master table</li>
  </ul>
  
  <p>I want to build a query that cross references an EVENT NUMBER from the master table to it's particular sub table. For example, someone gives me an event number. I can go to the EVENT MASTER TABLE and find it there, but I'd also like to find out which sub table it resides in.</p>