title: OleDB JOIN Syntax Not Correct
body: <p>I recently asked a question on StackOverflow (<a href="https://stackoverflow.com/questions/33802918/mysql-returns-all-rows-when-field-0/33803489?noredirect=1#comment55374618_33803489">MySQL Returns All Rows When field = 0</a>) regarding a query statement not working in <code>MySQL</code>. I now have a very similar problem, this time using <code>OleDB</code> where I am trying to use a join to include fields that have <code>0</code> as an entry, but not select every field in the table as a result. </p>
  
  <p>The new look <code>MySQL</code> query posted in the above question as the accepted answer works without a hitch. However the <code>OleDB</code> counterpart I have written to do almost the same does not. It's a bit messy as the tables are not named very well (I didn't create this database) and I'm getting a simple syntax error;</p>
  
  <pre><code>myQuery.CommandText = "SELECT s.scm_num, s.scm_name, c.cr3_text, q.qsp_value, s.scm_bprefix, s.scm_nxbnum FROM qspreset q INNER JOIN sdccomp s LEFT OUTER JOIN cntref3 c ON s.scm_cntref3=c.cr3_id AND q.qsp_relat=s.scm_invtype AND q.qsp_what=13";
  </code></pre>
  
  <p>I'm querying another table here as well as the two involved in the <code>LEFT OUTER JOIN</code> and I believe that is where I am making the mistake. </p>