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

1 vote192 views1 answer
Get specific columns using with() function in laravel eloquent
PHP Laravel
1 vote174 views4 answers
Laravel unique id
PHP Laravel
12 votes241 views4 answers
Laravel return redirect to named route
PHP Laravel
15 votes171 views3 answers
Laravel target class does not exist
PHP Laravel
0 vote159 views1 answer
Import class route laravel
PHP Laravel
18 votes165 views6 answers
Laravel unique validation
PHP Laravel
12 votes166 views6 answers
Laravel relationship
PHP Laravel
8 votes112 views2 answers
Laravel password hash online
PHP Laravel
-1 vote154 views4 answers
Laravel collection find
PHP Laravel
10 votes165 views3 answers
Migrate to an existing table in laravel commad
PHP Laravel