Laravel hasMany with join

public function earmarks() {
   return $this->hasMany('App\Earmark', 'labtop_id', 'id')
        ->join('locations', 'locations.id', '=', 'earmarks.location')
        ->select('earmarks.*', 'locations.location AS em_location')
        ->orderBy('date', 'asc')->get();
}

Source: stackoverflow.com

Similar codes

0 vote154 views1 answer
Woocommerce mini cart ajax count
PHP
0 vote130 views2 answers
Merge strings in php
PHP
92 votes197 views6 answers
Replace String in PHP
PHP
3 votes131 views1 answer
Php exercises
PHP
0 vote149 views1 answer
Find curren monday in laravel carbon
PHP Laravel
6 votes155 views5 answers
Migration rename column laravel
PHP Laravel
0 vote157 views1 answer
Php ?? vs ?:
PHP
0 vote148 views1 answer
Laravel check if model relation exists
PHP Laravel
0 vote140 views1 answer
String date less than now php
PHP
5 votes130 views3 answers
How to execute cmd command in php
PHP