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

9 votes355 views2 answers
A facade root has not been set laravel
PHP Laravel
0 vote350 views1 answer
Confiruando passaport no laravel
PHP Laravel
1 vote379 views1 answer
Laravel refresh server
PHP Laravel
1 vote381 views1 answer
How to return data in json format in laravel
PHP Laravel
0 vote395 views1 answer
Comment installer laravel avec docker
PHP Laravel
0 vote363 views2 answers
Laravel date format valdiate
PHP Laravel
0 vote351 views1 answer
Change regards line laravel
PHP Laravel
0 vote351 views1 answer
Laravel Dropzone Attachment Required is not working as expected
PHP Laravel
1 vote323 views1 answer
DB::connection('local')->create() laravel
PHP Laravel
7 votes359 views2 answers
How to start composer in laravel project on localhost
PHP Laravel