title: Left Join query with flag condition
body: <p>Hy, i have problems for show all the rows of a table <code>cash</code>, im trying to get the <code>cashassignment_id</code> column if the column doesn't have data then print <code>Unallocated</code> as result. But the <code>Cash 1</code> is Missing.</p>
  
  <p>My sql:</p>
  
  <pre><code>SELECT  
      cash.cash_id,
      cash.cash_name,
      IFNULL(cash_assignments.cashassignment_id, 'Unallocated') AS cashassignment_id
  FROM cash
      LEFT JOIN cash_assignments USING(cash_id)
  WHERE cash_assignments.cashassignment_valid = TRUE OR cash_assignments.cashassignment_valid IS NULL
  </code></pre>
  
  <p>Demo Link
  <a href="http://sqlfiddle.com/#!9/ce446/1/0" rel="nofollow">http://sqlfiddle.com/#!9/ce446/1/0</a></p>