title: Multiple LEFT JOIN (MS Access+VB.NET)
body: <p>I'm stuck in a query.</p>
  
  <p><strong>Tables:</strong></p>
  
  <p>In the 'favourites' table are stored favourite articles (products). </p>
  
  <p>in the "articles" table are stored all products avalaible.</p>
  
  <p>in the "providers" table are stored all providers of these products. The relation between products and providers are stored in "artPRov" table.</p>
  
  <p>In the table "invoices" are stored purchases.</p>
  
  <p><strong>RELATIONS</strong></p>
  
  <p><img src="https://i.stack.imgur.com/IXWbB.png" alt="RELATIONS"></p>
  
  <p><strong>QUERY</strong></p>
  
  <blockquote>
    <p>select favourites.*,articles.article,artProv.LastCost, invoice.idInv,
    providers.name
        FROM ((((favourites LEFT JOIN articles ON favourites.idArt=articles.idArt) LEFT JOIN providers ON
    favourites.idProv=providers.idProv) LEFT JOIN artProv ON
    favourites.idArt=artProv.idArt AND artProv.idProv=providers.idProv)
    LEFT JOIN invoices ON favourites.idInv=invoices.idInv)</p>
  </blockquote>
  
  <p><strong>join error:</strong>  </p>
  
  <pre><code>&gt; LEFT JOIN artProv ON favourites.idArt=artProv.idArt AND
  &gt; artProv.idProv=providers.idProv
  </code></pre>