title: How to merge 2 completely different tables?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1198124/combine-two-tables-that-have-no-common-fields">Combine two tables that have no common fields</a>  </p>
  </blockquote>
  
  
  
  <p>I'm looking at merging 2 tables, that have nothing in common (No columns, No IDs) into 1 single table.
  it's for reporting purposes. I need to just grab all the columns in table 1 and all the columns in table 2 and put them into 1 table, so the data doesn't change, it's just that instead of being in 2 tables they'll be into 1.</p>
  
  <p>Example</p>
  
  <p>Table1: <code>KeyboardID, Computermodel, factory</code></p>
  
  <p>Table2: <code>MouseID, Speakers, Circuitboard</code></p>
  
  <p>New table of those 2 combined: <code>KeyboardID, Computermodel, factory, MouseID, Speakers, Circuitboard</code></p>
  
  <p>Update: I'm gonna clarify myself:</p>
  
  <p>Here's my situation View1: <code>StarID, Planet, Sun</code> and then <code>View2: StarID, Planet, Sun</code> As you can see they have the exact same column names; Here's how I'm expecting my 3rd view to look like:</p>
  
  <p><code>StarID, Planet, Planet2, Sun, Sun2</code></p>
  
  <p>I would not mind having the 3rd view look like this:</p>
  
  <p><code>StarID, StarID2, Planet, Planet2, Sun, Sun2</code></p>
  
  <p>here's the catch, they do not relate at all, you're probably thinking "Join them on <code>StarID</code>" unfortunately I cant as technically I need <code>StarID</code> from View1 to be appended to <code>StarID</code> on View2 or have them in completely separate columns (this is because there's no relationship in the data) to complicate things, <code>StarID</code> may not be unique (I'm not sure if there's uniqueness constraints to views I'm fairly new to postgres)</p>