title: oracle 11g beginner - how to display data from two tables
body: <p>Complete beginner to Oracle 11g here.</p>
  
  <p>If I have two tables, with some overlapping attributes but no relation, how do I display all the data in one table?</p>
  
  <p>Example:</p>
  
  <pre><code>TABLE A has a PK, a fname, lname.  
  TABLE B has a PK, a fname, lname, phone.
  </code></pre>
  
  <p>I'd like to display the contents of <code>TABLE A</code> and <code>TABLE B</code> in one table.  </p>
  
  <p>I thought I could use a <code>UNION</code>, but you have to have the same number of columns; and since <code>TABLE B</code> has 3 columns, I get an error: <code>ORA-01789: query block has incorrect number of result columns.</code></p>