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 vote357 views1 answer
How to merge 2 laravel eloquent records
PHP Laravel
5 votes409 views4 answers
App url laravel
PHP Laravel
0 vote364 views2 answers
Composer create project laravel with version
PHP Laravel
5 votes385 views2 answers
Laravel - Send mail using mail class
PHP Laravel
0 vote352 views1 answer
Laravel carbon first day of month
PHP Laravel
18 votes352 views6 answers
Install laravel auth
PHP Laravel
0 vote363 views1 answer
If condition view page of laravel
PHP Laravel
0 vote339 views2 answers
Laravel filesystem
PHP Laravel
1 vote380 views2 answers
Get database name laravel
PHP Laravel
0 vote367 views1 answer
Find curren monday in laravel carbon
PHP Laravel