title: Hive: Not in subquery join
body: <p>I'm looking for a way to select all values from one table which do no exits in other table. This needs to be done on two variables, not one.</p>
  
  <pre><code>select * from tb1 
  where tb1.id1 not in (select id1 from tb2) 
  and tb1.id2 not in (select id2 from tb2)
  </code></pre>
  
  <p>I cannot use subquery. It needs to be done using joins only.</p>
  
  <p>I tried this:</p>
  
  <pre><code>select * from tb1 full join tb2 on
  tb1.id1=tb2.id1 and tb1.id2=tb2.id2
  </code></pre>
  
  <p>This works fine with one variable in condition, but not two. 
  Please suggest some resolution.</p>