title: SQL - Inner Join Syntax after the on statement
body: <p>So in my database I have these records that have serial key number to separate them from each other. However I want to join them with another table, where a person can have up to 2 serial numbers associated to their account like so.</p>
  
  <pre><code>|account #|Serial#1|Serial#2|
  ------------------------------------------
  |01234201 |P984564|P12388|
  ------------------------------------------
  </code></pre>
  
  <p>So my question is, can you set up an Inner Join query in the on statement to compare one column against two columns. eg.</p>
  
  <p><code>INNER JOIN datatable2 ON datatable1.Serial#1 OR datatabel2.Serial#2 = datatable2.serial#</code></p>