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 vote252 views1 answer
Change sender name laravel
PHP Laravel
1 vote243 views2 answers
Laravel eloquent join two models
PHP Laravel
2 votes208 views1 answer
Laravel asset
PHP Laravel
2 votes216 views1 answer
Laravel pivot table model
PHP Laravel
0 vote256 views2 answers
How to concat in where clause like laravel query builder
PHP Laravel
-1 vote215 views4 answers
Adminlte in laravel 8
PHP Laravel
0 vote230 views1 answer
Laravel get current domain
PHP Laravel
0 vote236 views1 answer
Post with count greater than 1 laravel
PHP Laravel
-2 votes297 views1 answer
Errno: 150 foreign key constraint is incorrectly formed laravel 8
PHP Laravel
2 votes227 views2 answers
How set variable public in static method in laravel
PHP Laravel