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 votes322 views2 answers
Laravel form method delete
PHP Laravel
1 vote349 views1 answer
Pass model in function laravel
PHP Laravel
1 vote339 views1 answer
How to return with open model popup in laravel
PHP Laravel
5 votes360 views2 answers
Collection laravel filter
PHP Laravel
0 vote342 views1 answer
Laravel change string to text
PHP Laravel
1 vote334 views5 answers
Laravel modules
PHP Laravel
6 votes333 views2 answers
Laravel route regex except
PHP Laravel
4 votes333 views3 answers
Laravel restore soft delete
PHP Laravel
1 vote321 views2 answers
Laravel model fillable vs guarded
PHP Laravel
11 votes359 views2 answers
How login one user with id in laravel
PHP Laravel