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 vote298 views1 answer
How to clear artisan in laravel
PHP Laravel
0 vote225 views1 answer
Laravel validate form data unique array
PHP Laravel
5 votes230 views3 answers
Laravel destroy session
PHP Laravel
-1 vote229 views1 answer
Laravel edit form select don't repeat a selected value
PHP Laravel
1 vote216 views1 answer
Integer default value laravel
PHP Laravel
0 vote210 views1 answer
Laravel validation rules for video upload
PHP Laravel
1 vote339 views1 answer
How to add property to the request object in laravel
PHP Laravel
8 votes280 views5 answers
Laravel route is current route
PHP Laravel
11 votes218 views2 answers
Laravel log level
PHP Laravel
11 votes231 views3 answers
Laravel running a specific migration on different path
PHP Laravel