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

5 votes384 views2 answers
Laravel chmod
PHP Laravel
0 vote335 views1 answer
Delete image s3 laravel
PHP Laravel
1 vote385 views1 answer
Laravel 8 $request->intersect not working
PHP Laravel
2 votes368 views3 answers
Where is in array laravel
PHP Laravel
0 vote435 views1 answer
Laravel nova create user
PHP Laravel
1 vote356 views1 answer
Laravel-cors
PHP Laravel
0 vote384 views1 answer
Laravel Auth::logoutOtherDevices
PHP Laravel
37 votes423 views6 answers
Laravel create or update
PHP Laravel
3 votes437 views1 answer
Php extensions for laravel
PHP Laravel
1 vote380 views1 answer
Set subject for mail inlaravel
PHP Laravel