title: MySQL - JOIN to Show Only Unmatched
body: <p><strong>Version</strong>: MySQL 8.0</p>
  <p><strong>Fiddle</strong> : <a href="https://www.db-fiddle.com/f/dZceV3UaHuo9KDQjhWqjP9/10" rel="nofollow noreferrer">https://www.db-fiddle.com/f/dZceV3UaHuo9KDQjhWqjP9/10</a></p>
  <p>I have a table of vehicles and a table of specifications. I need to query for which specifications are missing for a given vehicle.</p>
  <p>Example Data</p>
  <pre><code>============================================
  | tb_specificationtypes                    |
  ============================================
  | SpecificationTypeID | SpecificationType  |
  |-------------------------------------------
  |           1         | Color              |
  |           2         | Shape              |
  |           3         | Speed              |
  |           4         | Voltage            |
  ============================================
  
  
  ==========================================================================
  | tb_specifications                                                      |
  ==========================================================================
  | SpecificationTypeParent | SpecificationValue | SpecificationAssignment |
  |-------------------------------------------------------------------------
  |           1             | White              | CAR000                  |
  |           2             | Rounded            | CAR000                  |
  |           3             | Fast               | CAR000                  |
  |           1             | Red                | CAR001                  |
  |           4             | 12V                | CAR001                  |
  ==========================================================================
  </code></pre>
  <p>What I want to determine is, say, which specifications am I missing for a given vehicle.</p>
  <p>The result for <code>CAR000</code> should be:</p>
  <pre><code>Voltage
  </code></pre>
  <p>The result for <code>CAR001</code> should be:</p>
  <pre><code>Shape
  Speed
  </code></pre>
  <p>I have a <a href="https://www.db-fiddle.com/f/dZceV3UaHuo9KDQjhWqjP9/10" rel="nofollow noreferrer">SQL Fiddle</a> where I have prepopulated the tables with a little data and have a basic join. I have tried all types of joins, and have Googled every possible thing I can think of to describe the problem, but I'm out of ideas.</p>