title: SQL how to join two different tables columns as result
body: <p>I have two tables:</p>
  
  <p>table1:</p>
  
  <pre><code>---------------------------
  |id_column1 | name_column |
  ---------------------------
  |        1  | my_name1    |
  |        2  | my_name2    |
  ---------------------------
  </code></pre>
  
  <p>table2:</p>
  
  <pre><code>--------------------------------------
  |id_column2 | surname_column | fk_id1|
  --------------------------------------
  |      111  | my_surname1    | 1     |
  |      222  | my_surname2    | 2     |
  --------------------------------------
  fk_id1 is foreign key referenced to table1.id_column1
  
  SELECT * FROM table1 WHERE fk_id1=1;
  
  --------------------------------------
  |id_column2 | surname_column | fk_id1|
  --------------------------------------
  |      111  | my_surname1    | 1     |
  </code></pre>
  
  <p>How can I get this (is it possible at all to join two table columns as result):</p>
  
  <pre><code>------------------------------------------------
  |id_column2 | surname_column | fk_id1| name    |
  ------------------------------------------------
  |      111  | my_surname1    | 1     |my_name1 |
  </code></pre>
  
  <p>Something like below:</p>
  
  <pre><code>SELECT * FROM table2 WHERE fk_id1=1 AND SELECT name FROM table1 WHERE id_column1=1;
  </code></pre>