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 vote302 views2 answers
Laravel display category post by slug
PHP Laravel
0 vote297 views2 answers
Laravel set middleware default
PHP Laravel
24 votes300 views4 answers
Clear cache command in laravel controller
PHP Laravel
0 vote320 views1 answer
Id type laravel
PHP Laravel
0 vote306 views1 answer
Laravel auth without vue or bootstrap
PHP Laravel
4 votes289 views2 answers
Laravel collection count
PHP Laravel
0 vote313 views4 answers
Form::select laravel
PHP Laravel
0 vote309 views1 answer
Igaster\Laravel Theme\Exceptions\theme Already Exists
PHP Laravel
31 votes276 views3 answers
Carbon laravel use
PHP Laravel
2 votes279 views1 answer
Laravel guest blade
PHP Laravel