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 vote326 views4 answers
Laravel pluck relationship
PHP Laravel
0 vote318 views1 answer
Make() laravel
PHP Laravel
0 vote335 views1 answer
Laravel empty query result
PHP Laravel
0 vote317 views3 answers
Laravel query order by relation
PHP Laravel
15 votes328 views3 answers
Laravel make model with migration 5.8
PHP Laravel
0 vote324 views1 answer
Extension gd missing laravel composer update
PHP Laravel
53 votes438 views6 answers
Laravel join
PHP Laravel
3 votes334 views6 answers
Add to collection laravel
PHP Laravel
10 votes402 views4 answers
Laravel migration change column default
PHP Laravel
0 vote451 views1 answer
Laravel api cors localhost issue
PHP Laravel