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 vote151 views2 answers
Laravel create event listener
PHP Laravel
8 votes167 views1 answer
Laravel create symbolic link storage
PHP Laravel
0 vote162 views1 answer
Push to aws instance ssh without using laravel
PHP Laravel
1 vote158 views3 answers
Convert date to timestamp in laravel builder
PHP Laravel
1 vote114 views1 answer
Laravel check if eloquent just created
PHP Laravel
3 votes168 views1 answer
Back route laravel
PHP Laravel
0 vote161 views1 answer
Copy file from one directory to another Laravel
PHP Laravel
1 vote153 views1 answer
Laravel dusk run failed tests
PHP Laravel
0 vote146 views1 answer
How to update all row in laravel
PHP Laravel
0 vote138 views1 answer
Créer projet laravel
PHP Laravel