title: Multi Table NOT EQUAL in Access Query
body: <p>I have two tables. VEHICLES and OWNERSHIP. I am trying to make a query that will give me a list of all VEHICLES <strong>NOT</strong> in the OWNERSHIP table. I basically need a report of my available VEHICLE inventory. I tried this query:</p>
  
  <pre><code>SELECT VEHICLE.*
  FROM VEHICLE, OWNERSHIP
  WHERE (VEHICLE.VEH_ID &lt;&gt; OWNERSHIP.VEH_ID);
  </code></pre>
  
  <p>Im getting:<img src="https://i.stack.imgur.com/W5JdC.png" alt="enter image description here"></p>
  
  <p>When I do an equal I get all vehicles which are listed in the ownership so that works. But the NOT Equal does not. Any ideas?</p>