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

20 votes199 views6 answers
Laravel 8 make:auth
PHP Laravel
5 votes178 views2 answers
Throwexception laravel
PHP Laravel
2 votes134 views1 answer
Laravel create txt file
PHP Laravel
0 vote174 views1 answer
Call variable from inside a collection laravel
PHP Laravel
1 vote174 views1 answer
Persian error laravel
PHP Laravel
7 votes252 views4 answers
Laravel is route name
PHP Laravel
2 votes202 views2 answers
Laravel get default locale
PHP Laravel
7 votes185 views6 answers
Sort laravel eloquent
PHP Laravel
0 vote162 views1 answer
Handling deadlocks laravel
PHP Laravel
39 votes121 views2 answers
Create request laravel command
PHP Laravel