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 vote262 views1 answer
Add multi product at the same time using repearter default view laravel
PHP Laravel
1 vote247 views1 answer
Use model from variable laravel
PHP Laravel
0 vote268 views1 answer
Laravel create table with model command line
PHP Laravel
0 vote246 views1 answer
What is errore Personal access client not found. Please create one in laravel
PHP Laravel
10 votes255 views4 answers
Laravel migration set default value
PHP Laravel
0 vote248 views2 answers
Foreach limit laravel
PHP Laravel
19 votes244 views6 answers
Laravel logger
PHP Laravel
0 vote219 views1 answer
Laravel token logout
PHP Laravel
3 votes250 views3 answers
Laravel notification
PHP Laravel
-1 vote195 views2 answers
Laravel 5.6 orderby
PHP Laravel