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

15 votes225 views1 answer
Laravel skip requirements
PHP Laravel
0 vote219 views1 answer
Eager load relationships on an existing model in route laravel
PHP Laravel
0 vote219 views1 answer
Laravel array to string error
PHP Laravel
3 votes273 views2 answers
Get image width and height in laravel
PHP Laravel
35 votes224 views6 answers
Laravel db query
PHP Laravel
0 vote216 views1 answer
Beanstalk run laravel command
PHP Laravel
0 vote216 views1 answer
Seeder name singular or plural laravel
PHP Laravel
2 votes219 views2 answers
Laravel get file in public folder
PHP Laravel
0 vote210 views2 answers
Laravel retain old value
PHP Laravel
1 vote250 views1 answer
Laravel sprintf span in controller
PHP Laravel