title: Can you explain this SQL query?
body: <p>I don't understand how this query worked. Is it some advanced feature of mysql which I am not able to understand? </p>
  
  <pre><code>select A.id from A where A.id in (select B.id from  B where B.id = A.id)
  </code></pre>