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 vote123 views1 answer
How run job laravel in cpanel host
PHP Laravel
1 vote160 views4 answers
Laravel flash message
PHP Laravel
2 votes113 views1 answer
Laravel clear everything
PHP Laravel
0 vote135 views1 answer
Edit items in Laravel collection
PHP Laravel
1 vote122 views2 answers
Laravel view with data in blade
PHP Laravel
0 vote127 views2 answers
Laravel eloquent without relation
PHP Laravel
0 vote113 views2 answers
Add blade in blade laravel
PHP Laravel
0 vote132 views1 answer
Setup cron on macos for laravel
PHP Laravel
0 vote118 views2 answers
Laravel blade empty
PHP Laravel
0 vote124 views1 answer
Laravel-medialibrary packagist
PHP Laravel