title: Advanced Select statement (Laravel)
body: <p>In the Products table i have the store_id column which connects the product with the store. </p>
  
  <p>In my APIController which i use with Angular i have this return statement. I am returning a collection of products. </p>
  
  <pre><code>return Product::where('category_id', $category-&gt;id)
             -&gt;select(array('id', 'name', 'newprice', 'image',
                 'store_id', 'link'))
             -&gt;paginate(20);
  </code></pre>
  
  <p>My problem is that instead of returning the store_id(from the products table) i want to return the store name, which is NOT stored in the same table. Is there any way to do that?
  Is my only option the use of JOIN?</p>