title: SQL help different value on the same field
body: <p>I need help with a request.
  I've two tables : <code>ADDRESS</code> and <code>CUSTOM</code>
  I can link the two tables with <code>ADDRESS.ID = CUSTOM.ADDRESSID</code>
  And I want to select all the addresses where <code>CUSTOM.NAME = 'NUMBER'</code>
  and <code>CUSTOM.VALUE = '5'</code>
  But also, on these addresses, I want to display the field <code>CUSTOM.VALUE</code>, where <code>CUSTOM.NAME = 'INFO'</code></p>
  
  <p>Here is some exemples</p>
  
  <p>ADDRESS :</p>
  
  <pre><code> ID      NAME      STREET
   1       Paul     65 blue street
   2       John     50 red street
  </code></pre>
  
  <p>CUSTOM :</p>
  
  <pre><code>ID      IDADDRESS     NAME    VALUE
   1           1         NUMBER    5
   2           1         INFO      1st floor
   3           2         NUMBER    6
   4           2         INFO      no info
  </code></pre>
  
  <p>What I want in result is :
  Paul - 65 blue street - 1st floor</p>
  
  <p>Can someone help me with this request please ? 
  I tried :</p>
  
  <p><code>SELECT * FROM ADDRESS, CUSTOM WHERE ADDRESS.ID=CUSTOM.ADDRESSID AND         ((CUSTOM.NAME='NUMBER' AND CUSTOM.VALUE='5') OR CUSTOM.NAME='INFO')</code></p>