title: MySQL join and exclude?
body: <p>I have two tables, table A one with two columns: IP and ID, and table B with columns: ID and extra information. I want to extract the rows in table B for IPs that are not in table A. So if I have a rows in table A with</p>
  
  <pre><code>id = 1
  ip = 000.000.00
  id = 2
  ip = 111.111.11
  </code></pre>
  
  <p>and I have rows in table B</p>
  
  <pre><code>id = 1
  id = 2
  </code></pre>
  
  <p>then, given ip = 111.111.11, how can I return row 1 in table B?</p>