title: Matching two columns from different tables - MySQL PHP
body: <p>I have two tables in mysql</p>
  <ul>
  <li>table 1 is vehicles, has records of all vehicles</li>
  <li>table 2 is contributions, has records of daily contributions from the vehicles</li>
  </ul>
  <p>I have a column in both tables called <code>regno</code></p>
  <p>I want a query that will display <code>vehicle</code> <code>regno</code> that is not in <code>contributions</code></p>
  <p>What I tried:</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT vehicles.regno FROM vehicles,contributions
  WHERE vehicles.regno&lt;&gt;contributions.regno
  ORDER BY vehicles.regno;
  </code></pre>
  <p>Please help. thanks in advance.</p>