title: Select all Items which don't have a particular value in another table
body: <pre><code>Table: Car
  Columns: CarID, Value
  
  Table: Tyres
  Columns: TyreID, CarID, Brand
  </code></pre>
  
  <p>How can I select all <code>Cars</code> which don't have a corresponding <code>Tyre</code> which is of a certain <code>Brand</code>. In this scenario a car could have a number of different tyres each of which has a different brand.</p>
  
  <p>E.g. </p>
  
  <p>Car1 has 4 tyres, 2 x Brand A, 1 x Brand B, 1 x Brand C. <br/>
  Car2 has 3 tyres, 1 x Brand A, 2 x Brand B. <br/>
  Car3 has 4 tyres, 3 x Brand A, 1 x Brand C.</p>
  
  <p>I want to find out the CarID of all vehicles which don't have a single tyre of Brand C. In this instance the result would be Car2.</p>
  
  <p>Example Data:</p>
  
  <pre><code>Car
  CarID   Value
  --------------
  1       Abc
  2       Def
  3       Geh
  
  Tyre
  TyreID  CarID   Brand
  ----------------
  1       1   Brand A
  2       1   Brand A
  3       1   Brand B
  4       1   Brand C
  5       2   Brand A
  6       2   Brand B
  7       2   Brand B
  8       3   Brand A
  9       3   Brand A
  10      3   Brand A
  11      3   Brand C
  
  Result
  ID      2
  </code></pre>