title: how to use LEFT JOIN in mysql
body: <p>i am getting an error with my code and i would appreciate some help. this is just my first day trying to learn so please keep it as simple as possible thanks </p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that 
  corresponds to your MariaDB server version for the right syntax to use 
  near 'FROM specials LEFT JOIN products_description LEFT JOIN products 
  WHERE special' at line 2
  </code></pre>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>SELECT specials.specials_id, specials.products_id,specials_new_products_price, products.products_image,  products.products_price,products.products_image, products.products_quantity,products.products_model,products_description.products_name,products_description.products_description,
  FROM specials 
  LEFT JOIN  products_description
  LEFT JOIN  products
  WHERE specials.products_id = products.products_id AND specials.products_id = products_description.products_id AND products.products_quantity&gt;0</code></pre>
  </div>
  </div>
  </p>