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

4 votes136 views4 answers
Raw queries in laravel
PHP Laravel
23 votes105 views6 answers
Laravel logs
PHP Laravel
1 vote105 views1 answer
Laravel helper function for check string is exist in another string
PHP Laravel
1 vote124 views1 answer
Stack once laravel
PHP Laravel
5 votes115 views6 answers
New laravel 8 project
PHP Laravel
2 votes119 views2 answers
How get query from url in laravel
PHP Laravel
1 vote68 views1 answer
Redirect from laravel controller to another link
PHP Laravel
18 votes117 views4 answers
Laravel create model controller and migration on line
PHP Laravel
3 votes112 views1 answer
Validate each value from array laravel
PHP Laravel
3 votes119 views1 answer
Print session in laravel
PHP Laravel