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 vote210 views1 answer
Extensions for laravel command ubuntu 20.04
PHP Laravel
0 vote200 views1 answer
Laravel skip a loop if error
PHP Laravel
17 votes188 views4 answers
Laravel with trashed
PHP Laravel
2 votes197 views1 answer
Laravel where update query
PHP Laravel
1 vote219 views1 answer
Get specific columns using with() function in laravel eloquent
PHP Laravel
0 vote198 views1 answer
Seprate day and year from laravel to timestamp
PHP Laravel
5 votes196 views2 answers
Laravel groupby and latest
PHP Laravel
0 vote239 views1 answer
Laravel app running in console
PHP Laravel
0 vote191 views1 answer
Loop object property laravel
PHP Laravel
35 votes210 views6 answers
Laravel db query
PHP Laravel