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 votes215 views3 answers
Laravel migration seed fresh
PHP Laravel
2 votes203 views2 answers
File exist check in laravel blade
PHP Laravel
0 vote211 views3 answers
Passing data from controller to blade view laravel
PHP Laravel
9 votes201 views3 answers
Laravel load view in variable
PHP Laravel
1 vote206 views2 answers
Laravel observer get old value
PHP Laravel
4 votes213 views1 answer
How to check query execution time in laravel
PHP Laravel
0 vote203 views2 answers
Laravel General error: 1215 Cannot add foreign key constraint"
PHP Laravel
-1 vote211 views4 answers
Laravel create command tutorial
PHP Laravel
0 vote215 views1 answer
Bootswatch import theme into laravell vuejs
PHP Laravel
2 votes232 views1 answer
Laravel schema default string length
PHP Laravel