title: How can I select lines with specific data when I have 2 lines with the same ID?
body: <p>I need your help again ! 
  I'm trying to have a specific result in SQL 
  I have a SQL Query like : </p>
  
  <pre><code>Select ID, DOCUMENTATION, FIELDCODE FROM TABLE.
  </code></pre>
  
  <p>The result is :</p>
  
  <pre><code>ID  DOCUMENTATION   FIELDCODE
  1   testDoc         0
  1   NULL            202
  2   NULL            202
  3   NULL            202
  4   testDoc2        0
  4   NULL            202
  </code></pre>
  
  <p>However, I want to have : </p>
  
  <pre><code>ID  DOCUMENTATION   FIELDCODE
  1   testDoc         0
  2   NULL            202
  3   NULL            202
  4   testDoc2        0
  </code></pre>
  
  <p>To sum up : </p>
  
  <ul>
  <li>I want to have the fieldcode 0 when it exist </li>
  <li>If the fieldcode 0 isn't exist, I want the fieldcode 202 </li>
  <li>The fieldcode id will always be 202</li>
  <li>the documentation for the 202 fieldcode will be always set to NULL </li>
  <li>the fieldcode with a documentation will always be 0</li>
  <li>I'm building the documentation with a case : if the fieldcode is 202 -> set NULL else print the good documentation. </li>
  </ul>
  
  <p>My problem is the documentation. The documentation is not the same. I cannot use MIN... </p>
  
  <p>I did not find solution yet. </p>
  
  <p>Thanks,</p>