title: how to use this without subquery. I need to use with join to get same result set
body: <p>How to use this below query as join instead of subquery. It's resulting poor performance</p>
  
  <pre><code>    SELECT EBIJ.* FROM BUDLINEITEMS EBIJ
  WHERE ReferenceId NOT IN (SELECT ImportKeyId FROM External_Blk_Itm_JounalEntries)
  </code></pre>