title: Cannot retrieve rows from .NET OleDB.DataReader
body: <p>i have a problem with a SQL Statement.</p>
  
  <p>My environment is as follows:</p>
  
  <ul>
  <li>VB.NET application that queries a MS Access (2002) through the .NET OleDB.DataReader</li>
  </ul>
  
  <p>That query doesn't deliver any rows/results. But when i execute the query on the MS Access database it delivers the correct result.</p>
  
  <p>The query is:</p>
  
  <pre><code>&lt;i&gt;select prnr.prk, prnr.prl, famk, faml from 
  (fzgpr inner join prnr on prnr.id = fzgpr.prid) 
  inner join prfamilie on prfamilie.id = prnr.famid 
  where ((fzgpr.fzgid) = 1) and ((FamL) like '*Air*')&lt;/i&gt;
  </code></pre>
  
  <p>I tried different brackets, but none worked. I noticed, that removing the second part of the where clause (and ((FamL)...) solves that issue, but i need that second part!!</p>
  
  <p>I can't find the error, please help me,...</p>