title: SQL Select non intersecting elements from the super set
body: <p><a href="https://i.stack.imgur.com/27Zcp.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/27Zcp.jpg" alt="enter image description here"></a></p>
  
  <p>How to choose the records in A that doesn't intersect with B? The records in A and B are already derived from a couple of inner joins. I tried left join, and right and not exists too, it's giving inappropriate results.</p>