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

1 vote246 views4 answers
Laravel scheduler run
PHP Laravel
17 votes213 views10 answers
Laravel where and where
PHP Laravel
42 votes294 views6 answers
Laravel cache remember
PHP Laravel
0 vote190 views1 answer
Request file create cammand laravel
PHP Laravel
1 vote194 views2 answers
Laravel query relationship nested
PHP Laravel
1 vote211 views2 answers
Pass image path in laravel blade
PHP Laravel
31 votes206 views6 answers
Make model with migration laravel
PHP Laravel
1 vote195 views1 answer
DB::connection('local')->create() laravel
PHP Laravel
0 vote341 views4 answers
Findmany laravel
PHP Laravel
0 vote183 views1 answer
Laravel-medialibrary change name of file
PHP Laravel