title: sql: afficher Les articles sans aucune vente en 2010
body: <p>My tables:</p>
  <p>sinvoiced</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>num_facture</th>
  <th>ITEM_REF</th>
  <th>date</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>a</td>
  <td>2010-01-31 00:00:00.000</td>
  </tr>
  <tr>
  <td>2</td>
  <td>b</td>
  <td>2011-01-31 00:00:00.000</td>
  </tr>
  <tr>
  <td>3</td>
  <td>c</td>
  <td>2012-01-31 00:00:00.000</td>
  </tr>
  <tr>
  <td>4</td>
  <td>d</td>
  <td>2013-01-31 00:00:00.000</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>itmsales</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ITEM_REF</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>a</td>
  </tr>
  <tr>
  <td>b</td>
  </tr>
  <tr>
  <td>c</td>
  </tr>
  <tr>
  <td>d</td>
  </tr>
  <tr>
  <td>e</td>
  </tr>
  <tr>
  <td>f</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>sql: display Items without any sales in 2010</p>
  <p>I want to display items without any sale in 2010</p>