title: Join two tables with one table
body: <p>I need to do the following (I am not really sure if it is possible to do using SQL)</p>
  
  <h2>Table A</h2>
  
  <p>col_a_1, col_a_2, col_a_3</p>
  
  <h2>Table B</h2>
  
  <p>col_a_1, col_b_1, col_b_2....</p>
  
  <h2>Table C</h2>
  
  <p>col_a_1, col_c_1, col_c_2....</p>
  
  <p>were col_a_1 is unique in table A. I need to join tables A, B, C such that every entry in table A will appear multiple times but every entry in table B and C appears only once and against the same col_a_1 of table A.</p>
  
  <p>I know how to do it using the code. Is it also possible to do with SQL alone?</p>
  
  <p>Thanks in advance.</p>