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 vote325 views1 answer
Get age with carbon in laravel
PHP Laravel
0 vote348 views1 answer
Laravel eloquent pass to next element
PHP Laravel
2 votes279 views2 answers
Wordpress add jquery script
PHP
0 vote308 views1 answer
Php memory usage view
PHP
0 vote311 views1 answer
Laravel route not calling function of controller
PHP Laravel
0 vote298 views2 answers
Iteration over jQuery object
PHP
1 vote294 views2 answers
Laravel collection implode
PHP
0 vote315 views3 answers
Laravel postgres deadlock
PHP Laravel
3 votes300 views1 answer
Sum multiple fields separately in laravel
PHP Laravel
3 votes283 views3 answers
Vc_map type number
PHP