title: Left Join with Find in set
body: <p>I have tables as follows :</p>
  
  <pre><code>TABLE A
  +-----+---------------+-------------+
  | ID  | DNR_DETAIL_ID | DESCRIPTION |
  +-----+---------------+-------------+
  |  1  |       1       |   DESC A    |
  +-----+---------------+-------------+
  |  2  |       2       |   DESC B    |
  +-----+---------------+-------------+
  |  3  |       3       |   DESC C    |
  +-----+---------------+-------------+
  
  
  TABLE B
  +--------+---------------+
  | DNR_ID | DNR_DETAIL_ID |
  +------------------------+
  |   1    |     1,2       |
  +--------+---------------+
  |   2    |       3       |
  +--------+---------------+
  </code></pre>
  
  <p>As you can see, <code>DNR_DETAIL_ID</code> columns are common in both tables. What I want to do, left joining both tables with field values ( null or not )</p>
  
  <pre><code>THE RESULT SHOULD BE (IF DNR_ID = 1) :
  +-------------+---------+
  | DESCRIPTION | CHECKED |
  +-------------+---------+
  |    DESC A   |    1    |
  +-------------+---------+
  |    DESC B   |    1    |
  +-------------+---------+
  |    DESC C   |    0    |
  +-------------+---------+
  </code></pre>