title: How to show records from two different tables in same view in laravel
body: <p>I am here stuck in this issue:
  The issue is i want to load the 2 column values from two different tables in same view and view in which i want to show the values is already having controller method: 
  I will explain you with my code: </p>
  
  <p>My controller method:</p>
  
  <pre><code>                   public function pageListHere()
     {
                     $list = PageList::all();
                     return view('page-list',compact('list'));
  }
  </code></pre>
  
  <p>this is my method using <code>PageList</code> model table name is (<code>page_master</code>).</p>
  
  <p>And my view is:</p>
  
  <pre><code>            @foreach($list as $key =&gt; $value)
              &lt;tr&gt;
              &lt;input type="hidden" id="rwid" value="{{$value-&gt;id}}"/&gt;&lt;td&gt;&lt;/td&gt;
              &lt;td&gt;&lt;p data-placement="top" data-toggle="tooltip" title="" data-original-title="Tolltip"&gt;{{$value-&gt;page_name}}&lt;/p&gt;&lt;/td&gt;
              &lt;td&gt;  &lt;a href="" class="pglst-lnk"&gt;  {{$value-&gt;page_url}&lt;/a&lt;/td&gt;
             &lt;td&gt;  
  </code></pre>
  
  <p>Now here i want to add two more values in blade template like <code>{{$value-&gt;coupon_count}}</code> and <code>{{$value-&gt;total sum}}</code>
  But these two values are in different tables
  How i can get these two values from  different tables while i am having same views and i have already define controller method:</p>
  
  <p>Any help would be highly appreciated!!</p>
  
  <pre><code>    class PageList extends Model
       {
       protected $table = 'page_master';
  
      protected $appends = ['page_particulars','page_coupon'];
  
      protected $fillable = ['business_id', 'page_url', 'page_name'];
  
     public function getpageParticularsAttribute(){
  
  
    }
  public function getpageCouponAttribute(){
  
        }
    }
  
                class PageCoupon extends Model
                 {
               protected $table = 'page_coupon';
  
           protected $fillable = ['page_id','code','is_ordered','user_limit'];
  
         }
  </code></pre>
  
  <p>and 2nd model is:</p>
  
  <pre><code>               class Sale extends Model
                 {
                  protected $table = 'page_particulars';
  
  protected $fillable = ['user_id','product_asin','page_expiry_date','market_place','promo_title','regular_price','promo_price','company_logo','coupon_file','email_from','email_subject','facebook_link','twitter_link','website_link','email_body'];
  </code></pre>
  
  <p>}</p>