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 vote419 views2 answers
Php mb_convert_encoding utf8 extended
PHP
0 vote367 views1 answer
Country code validation in laravel
PHP Laravel
0 vote373 views2 answers
Create file in laravel
PHP Laravel
0 vote319 views1 answer
Symfony see all make commands
PHP
10 votes382 views2 answers
Array to string conversion in laravel controller
PHP Laravel
0 vote287 views1 answer
WithErrors laravel
PHP
0 vote383 views2 answers
Shop page url woocommerce
PHP
0 vote325 views1 answer
Laravel Dropzone Attachment Required is not working as expected
PHP Laravel
4 votes365 views4 answers
Laravel carbon get day name
PHP Laravel
0 vote310 views1 answer
Twig request
PHP