title: How to use subquery to drop rows from Tab1 which are in Tab2 in Oracle SQL?
body: <p>I have tables in Oracle SQL like below:</p>
  <p>Tab1</p>
  <pre><code>ID
  -----
  1
  2
  3
  </code></pre>
  <p>Tab2</p>
  <pre><code>ID
  -----
  3
  4
  5
  </code></pre>
  <p>And I need to take values from Tab1 which are not in Tab2. I made query like below:</p>
  <pre><code>select ID
  from Tab1
  where ID not in (select ID from Tab2)
  </code></pre>
  <p>Above query does not work, how can I change it to achieve result as I need:</p>
  <pre><code>ID
  ---
  1
  2
  </code></pre>
  <p>I can add that I prefere to use subquery in this problem, how can I do that in Oracle SQL ?</p>