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 vote353 views1 answer
Laravel collection pipe
PHP Laravel
8 votes344 views1 answer
Laravel store link
PHP Laravel
9 votes371 views3 answers
Pass variable to blade laravel
PHP Laravel
0 vote346 views1 answer
Excel return integer from date column laravel
PHP Laravel
18 votes354 views1 answer
Laravel migation error
PHP Laravel
0 vote364 views1 answer
Add selected to dropdpown item laravel
PHP Laravel
20 votes342 views2 answers
Schema error laravel
PHP Laravel
1 vote372 views1 answer
Laravel query select from table where id != to another table id
PHP Laravel
0 vote337 views1 answer
Laravel 6 use username on url
PHP Laravel
0 vote376 views2 answers
Laravel filemanger choose multiple images
PHP Laravel