title: MySQL full inner join
body: <p>I have </p>
  
  <pre><code>SELECT clientReport.id 
  FROM clientReport 
  LEFT JOIN report02 ON (report02.id = clientReport.id)
  WHERE report02.id is null;
  </code></pre>
  
  <p>that does the equivalent of </p>
  
  <pre><code>SELECT clientReport.id
  WHERE clientReport.rowNumber NOT EXISTS (
  SELECT clientReport.rowNumber FROM report02, clientReport
  WHERE report02.id=clientReport.id);
  </code></pre>
  
  <p>I need, presumably, a full inner join to also get mismatches in report02, not just clientReport. How do I write the join to do this?</p>