title: Select all from one table where some columns match another select
body: <p>I have two differents tables. The have some columns in common, for this example lets say 'name' and 'id'.</p>
  
  <p>By making</p>
  
  <pre><code>(   SELECT name,id FROM table1
      EXCEPT
      SELECT name,id FROM table2)  
  UNION ALL
  (   SELECT name,id FROM table2
      EXCEPT
      SELECT name,id FROM table1)
  </code></pre>
  
  <p>I get a list of the elements that are on one tablet but not in the other one.</p>
  
  <p>Up to this point everything is OK.</p>
  
  <p>But now, I want to make a select all from <code>table1</code> where the name and the id matches the result of the query above.</p>