title: Delete from a table according to another table
body: <p>I want to delete records from a table according to another table.
  for example this is the base table:</p>
  
  <pre><code>table1:
  License    Major
  9           0012 
  8           0015
  7           0018 
  9           0019
  </code></pre>
  
  <p>and I want to delete items in table1 according to table2:</p>
  
  <pre><code>table2:
  License    Major 
  8           0015
  7           0018 
  9           0019
  </code></pre>
  
  <p>something like this: </p>
  
  <pre><code>delete from table1 
  where table1.license=table2.license 
        and table1.major=table2.major
  </code></pre>