title: How to Join two different tables in Laravel
body: <blockquote>
    <p>QueryException in Connection.php line 729:
    SQLSTATE[42S22]: Column not found: 1054 Unknown column 'site_name' in
    'where clause' (SQL: select <code>email_date</code>, <code>url</code>, <code>recipient</code> from
    <code>report_list</code> where <code>site_name</code> = mywebsite)</p>
  </blockquote>
  
  <pre><code>$records = DB::table('report_list')
                -&gt;select('email_date','url','recipient') 
                -&gt;where('site_name',$site_name)
                -&gt;get();
  return records;
  
  return view('monthlyReport')
             -&gt;with('records',$records)
             -&gt;with('site_name',$site_name);
  </code></pre>
  
  <p>My <code>site_name</code> was on different table and I don't know if I need to put Join or Make a model for this two. </p>
  
  <p>Can someone help me with this query?</p>