title: SQL Request for joining a table and printing its column twice in the result table
body: <p>There are two tables (A, B) in my database and I'm trying to join them and print the same column of table B twice in the result table. The problem is that I need to put in compliance with two different columns of table A, so to join these tables also twice. I tried to join them and put in the select expression required column two times, but in this case result table shows the same relation in every column.
  Here is the result I want, where the <code>id</code> column of table B includes <code>id_1</code> and <code>id_2</code> from table A and the output names correspond to ids from table A.</p>
  <p><code>Table A: (integer id_1, integer id_2)</code></p>
  <p><code>Table B: (integer id, varchar name)</code></p>
  <p><code>Result Table: (id_1, name, id_2, name)</code></p>