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

27 votes203 views3 answers
Laravel what is migrations
PHP Laravel
2 votes156 views1 answer
Laravel get only relationship
PHP Laravel
0 vote137 views1 answer
Laravel chunk select
PHP Laravel
0 vote138 views3 answers
Laravel migration softdelete
PHP Laravel
0 vote171 views1 answer
How to update request all value in laravel controller before save in database
PHP Laravel
0 vote139 views1 answer
How to update a table based on three columns laravel
PHP Laravel
4 votes132 views1 answer
Use str laravel
PHP Laravel
0 vote148 views1 answer
Copy file from one directory to another Laravel
PHP Laravel
0 vote165 views1 answer
Laravel get file to browser send
PHP Laravel
0 vote137 views1 answer
How to extract code from controller to helpers or other method in laravel
PHP Laravel