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

5 votes188 views4 answers
Update column type laravel migration
PHP Laravel
14 votes158 views3 answers
Change returning datetime timezone to recalculate with user timezone laravel
PHP Laravel
0 vote200 views1 answer
Link fake data in seeder laravel
PHP Laravel
1 vote217 views2 answers
Laravel JWTAuthentication
PHP Laravel
0 vote162 views2 answers
Access paginator object attribute in laravel
PHP Laravel
0 vote157 views1 answer
Laravel disable config cache
PHP Laravel
7 votes159 views3 answers
Laravel - Query Builder Left join
PHP Laravel
0 vote146 views1 answer
Laravel query with optional filter
PHP Laravel
0 vote165 views3 answers
Laravel pagination with search filter
PHP Laravel
0 vote161 views1 answer
Laravel many to many relation update
PHP Laravel