title: Convert Sub-Query with "not in" operator to join
body: <p>Is it possible to convert a sub-query with NOT IN operator to join? I need this query using joins</p>
  
  <pre>
  SELECT *
  FROM Contacts
  WHERE ContactIntID NOT IN(
      SELECT LinkToIntID
      FROM Requirements
      WHERE Requirements.uuJobStatus = 'Open')
  </pre>