title: Android ORMLite. LEFT join. WHERE clause
body: <pre><code>QueryBuilder&lt;Answer, Integer&gt; queryBuilder = helper.getAnswerDao().queryBuilder();
  QueryBuilder&lt;Question, Integer&gt; questionQueryBuilder = helper.getQuestionDao().queryBuilder();
  
  questionQueryBuilder.where().eq(Question.TYPE_COLUMN_NAME, "table");            
  queryBuilder.leftJoin(questionQueryBuilder);
  
  queryBuilder.where().eq(Answer.PICKED_COLUMN_NAME, true);
  
  pickedAnswers = queryBuilder.query();
  </code></pre>
  
  <p>Generated SQL statement:</p>
  
  <pre><code>SELECT `Answers`.* 
  FROM `Answers`
      LEFT JOIN `Questions` ON `Answers`.`questionId` = `Questions`.`id`
  WHERE `Answers`.`picked` = 1
      AND (`Questions`.`type` = 'table' )
  </code></pre>
  
  <p>This query returns empty result set due to 'AND' logical operation. This is default behaviour of ORMLite. Is any possibility to change where clause conjuction with 'OR' operation?</p>
  
  <p>I have tried: <code>queryBuilder.where().or()</code> before <code>queryBuilder.where().eq(Answer.PICKED_COLUMN_NAME, true)</code> and <code>queryBuilder.where().or(2)</code> after all <code>where()</code> methods. </p>