title: Join two tables with same ID and merge ID columns
body: <p>This is probably a pretty simple question, but most of the searches I do have to do with merging rows (not merging columns) or concatenating them.</p>
  
  <p>I want to join two tables on an ID column, but I only want it to return a single ID column.</p>
  
  <p>Example:</p>
  
  <p>Table 1:</p>
  
  <pre><code>ID|Data1|Data2
  </code></pre>
  
  <p>Table2:</p>
  
  <pre><code>ID|Data3|Data4
  </code></pre>
  
  <p>I want it to return:</p>
  
  <pre><code>ID|Data1|Data2|Data3|Data4
  </code></pre>
  
  <p>EDIT:</p>
  
  <p>I realize I can specify every column, but there are actually closer to 50 columns that I'm bringing over and I would prefer not to have to specify every single one. Is there a way to do this without specifying each column to bring over from the query?</p>
  
  <p>I believe natural join is what I need, but see this error I'm getting:</p>
  
  <pre><code>SELECT *
  FROM allqachecklists t1
  WHERE t1.IsIncorrect=1
  NATURAL JOIN (SELECT QAID, PMC, SiteName, Submitter, QAer FROM qabin.allqas) t2
  </code></pre>
  
  <p>1 errors were found during analysis.</p>
  
  <p>Unrecognized keyword. (near "NATURAL" at position 59)</p>