title: SQL Query for Finding All Records Without a Certain Value
body: <p>I have a table with two columns, albumID and photoID.</p>
  
  <p>How would I return a column of all the photoID's that are not in an albumID?</p>
  
  <p>For example, say I have this table and I want to find all the photoID's that are not in album 0.</p>
  
  <pre><code>|albumID|photoID|  
  |0      |0      |  
  |0      |1      |  
  |1      |0      |  
  |1      |2      |  
  |1      |3      |  
  </code></pre>
  
  <p>Then, I would only want to display photos 2 and 3.
  Right now, I only have this query: </p>
  
  <pre><code>SELECT DISTINCT photoID FROM PhotoInAlbum WHERE AlbumID &lt;&gt; 1
  </code></pre>
  
  <p>which returns photos 0,2,3, but 0 appears in album 0.</p>
  
  <p>Thanks so much!</p>