title: Mysql JOIN (multiple) tables
body: <p>I have 3 tables. 2 of them are the same (same columns, different data), and the third has some info data about other 2. Database looks like this:</p>
  
  <p>Table 1:</p>
  
  <pre><code>+--------------+
  |  ID | Name   |
  +--------------+
  | 1  | Table 2 |
  | 2  | Table 3 |
  +--------------+
  </code></pre>
  
  <p>Table 2:</p>
  
  <pre><code>+-------------------------------+
  | Name | Temperature | Pressure |
  +-------------------------------+
  | Table 2 |    22    | 1013     |
  +-------------------------------+
  </code></pre>
  
  <p>Table 3:</p>
  
  <pre><code>+-------------------------------+
  | Name | Temperature | Pressure |
  +-------------------------------+
  | Table 3 |    20    | 1009     |
  +-------------------------------+
  </code></pre>
  
  <p>I'm trying to JOIN all into one table, which should look like this:</p>
  
  <pre><code>+-------------------------------+
  | Name | Temperature | Pressure |
  +-------------------------------+
  | Table 2 |    22    | 1013     |
  | Table 3 |    20    | 1009     |
  +-------------------------------+
  </code></pre>
  
  <p>Any idea how sql query should look like? </p>
  
  <p>Thanks</p>