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

8 votes283 views6 answers
Relationship in laravel
PHP Laravel
12 votes285 views3 answers
Carbon in laravel documentation
PHP Laravel
5 votes325 views2 answers
Laravel redirect with message to section
PHP Laravel
18 votes306 views4 answers
Create model view controller laravel
PHP Laravel
0 vote296 views1 answer
Check if variable is set and not empty laravel
PHP Laravel
-1 vote312 views1 answer
Laravel Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on
PHP Laravel
0 vote290 views1 answer
Chart trong laravel
PHP Laravel
2 votes307 views3 answers
Laravel where created_at today
PHP Laravel
0 vote307 views1 answer
Laravel permit only some inputs
PHP Laravel
0 vote272 views1 answer
Laravel handle queryexception
PHP Laravel