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

15 votes93 views6 answers
Php array to object
PHP
12 votes97 views2 answers
Tomorrow carbon laravel
PHP
24 votes93 views2 answers
Clear laravel cache and clear vue
PHP
1 vote99 views1 answer
How to check leap year in php?
PHP
14 votes144 views6 answers
Laravel create model and migration
PHP
1 vote114 views1 answer
Fecade Artisan:call laravel
PHP Laravel
0 vote110 views2 answers
Str lower laravel
PHP Laravel
0 vote153 views1 answer
Comment désactiver la barre latérale Widgets sur des pages spécifiques WordPress
PHP Wordpress
3 votes113 views1 answer
Validate each value from array laravel
PHP Laravel
0 vote109 views1 answer
Laravel validatrion check should be null
PHP