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

7 votes143 views5 answers
Jetstream laravel
PHP Laravel
0 vote152 views1 answer
Laravel validation unique if this field is changed
PHP Laravel
13 votes141 views6 answers
Laravel api routes
PHP Laravel
1 vote180 views5 answers
Laravel eloquent batch insert
PHP Laravel
0 vote141 views1 answer
Laravel vue build production
PHP Laravel
0 vote161 views1 answer
Laravel use npm package
PHP Laravel
28 votes154 views5 answers
Migrate specific table laravel
PHP Laravel
11 votes245 views6 answers
Redirect route with parameters laravel
PHP Laravel
0 vote140 views1 answer
How to disable auto prediction html input in laravel
PHP Laravel
0 vote153 views1 answer
Create a exporter in laravel command
PHP Laravel