title: How can I pull data from multiple sql tables using a join statement
body: <p>I'm designing a simple in-office ticket system, and would like to include a field for the party responsible for the next action. To do so right this moment I'm thinking of using <code>tableName</code> and <code>tableID</code> as specifiers for the specific responsible party (could be a technician, customer, or third party, all in different tables)</p>
  
  <p>It would be fine to pull that data in and run another select call using the name of the table as a parameter, but the extra data flow slows things down significantly.</p>
  
  <p>Is there a way to use a single join statement to return the details of the party with a column for the table name and one for the individual table id or is there a better way to store the data from multiple potential tables?</p>