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 vote389 views1 answer
Laravel create new file if not exists
PHP Laravel
56 votes486 views6 answers
Laravel seeder
PHP Laravel
3 votes399 views3 answers
Laravel pagination having raw query not working
PHP Laravel
0 vote403 views1 answer
Laravel collection zip
PHP Laravel
0 vote377 views1 answer
Show sender name laravel
PHP Laravel
0 vote385 views2 answers
How to use php in laravel blade
PHP Laravel
1 vote364 views1 answer
Insert data using model in laravel 8
PHP Laravel
0 vote381 views2 answers
Laravel display category post by slug
PHP Laravel
57 votes480 views6 answers
How to create migration in laravel
PHP Laravel
3 votes414 views2 answers
{{Str::limit laravel
PHP Laravel