title: Joining 2 tables with 1 table referencing twice on 2 different column
body: <p>I need help on this particular problem I have</p>
  <p>Lets say given these 2 tables contain these fields</p>
  <pre><code>
  Table A
  
  Account_no | expiry_date
  
  Table B 
  
  Id | Account_no | Account_no
  
  </code></pre>
  <p>Am I able to join the results together</p>
  <p>Such that it becomes</p>
  <p><code>Id | Table A | Table A </code></p>
  <p>Given that some of the account no in table B is nullable. An example of this is</p>
  <pre><code>Table B
  
  1 | 123 | 124
  
  2 | 222 | null
  </code></pre>