title: Adding the results of two select queries into one table row with PostgreSQL
body: <p>I am attempting to return the result of two distinct select statements into one row in PostgreSQL. For example, I have two queries each that return the same number of rows:</p>
  
  <p>Select tableid1, tableid2, tableid3 from table1</p>
  
  <pre><code>+----------+----------+----------+
  | tableid1 | tableid2 | tableid3 |
  +----------+----------+----------+
  |        1 |        2 |        3 |
  |        4 |        5 |        6 |
  +----------+----------+----------+ 
  </code></pre>
  
  <p>Select table2id1, table2id2, table2id3, table2id4 from table2</p>
  
  <pre><code>+-----------+-----------+-----------+-----------+
  | table2id1 | table2id2 | table2id3 | table2id4 |
  +-----------+-----------+-----------+-----------+
  |         7 |         8 |         9 |        15 |
  |        10 |        11 |        12 |        19 |
  +-----------+-----------+-----------+-----------+
  </code></pre>
  
  <p>Now i want to concatenate these tables keeping the same number of rows. I do not want to join on any values. The desired result would look like the following:</p>
  
  <pre><code>+----------+----------+----------+-----------+-----------+-----------+-----------+
  | tableid1 | tableid2 | tableid3 | table2id1 | table2id2 | table2id3 | table2id4 |
  +----------+----------+----------+-----------+-----------+-----------+-----------+
  |        1 |        2 |        3 |         7 |         8 |         9 |        15 |
  |        4 |        5 |        6 |        10 |        11 |        12 |        19 |
  +----------+----------+----------+-----------+-----------+-----------+-----------+
  </code></pre>
  
  <p>What can I do to the two above queries (select * from table1) and (select * from table2) to return the desired result above.</p>
  
  <p>Thanks!</p>