title: eloquent where not in query?
body: <p>I'm trying to build the following sql query with eloquent. The query gives me all records from table_a which are in the list of ids and do not appear in table_b.</p>
  
  <pre><code>select * from table_a 
  where id in (1,2,3)
     and id not in 
        (select tablea_id from table_b 
         where tablea_id in (1,2,3))
  </code></pre>
  
  <p>So how do I do it in eloquent ? I want to avoid using a raw query.</p>
  
  <pre><code>//does not work
  TableA::whereIn('id',$ids)
     -&gt;whereNotIn('id', TableB::select('tabla_id')-&gt;whereIn($ids));
  </code></pre>