title: Select all records from one table that do not exist in another table in Laravel 5.1
body: <p>I want to get all the records from a table which do not exist in other table in Laravel 5.1.</p>
  
  <p>I know how to do this in core php, and it works fine with the following code</p>
  
  <pre><code>SELECT t1.name
  FROM table1 t1
  LEFT JOIN table2 t2 ON t2.name = t1.name
  WHERE t2.name IS NULL
  </code></pre>
  
  <p><strong>the model</strong></p>
  
  <pre><code>public function audiences() 
  { 
  return $this-&gt;belongsTo('App\BridalRequest', 'request_id'); 
  }
  </code></pre>
  
  <p>but when i try to do the same in Laravel by using the following code,</p>
  
  <pre><code>$all_bridal_requests_check = \DB::table('bridal_requests')
                      -&gt;where(function($query)
                      {
                          $query-&gt;where('publisher', '=', 'bq-quotes.sb.com')
                                -&gt;orWhere('publisher', '=', 'bq-wd.com-bsf');
                      })
                      -&gt;whereNotIn('id', function($query) { $query-&gt;table('audiences')-&gt;select('request_id'); })
                      -&gt;orderBy('created_on', 'desc')
                      -&gt;get();
  </code></pre>
  
  <p>then it gives me this error  </p>
  
  <blockquote>
    <p>Call to undefined method Illuminate\Database\Query\Builder::table()</p>
  </blockquote>