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

7 votes257 views2 answers
Laravel encrypt database fields
PHP Laravel
1 vote313 views1 answer
Paystack gateway integration laravel
PHP Laravel
0 vote312 views1 answer
Creating default object from empty value laravel
PHP Laravel
1 vote357 views3 answers
Import faker in laravel
PHP Laravel
1 vote366 views1 answer
--prefer-dist what is use in laravel
PHP Laravel
2 votes349 views3 answers
How to change the colum type in migration laravel
PHP Laravel
0 vote312 views1 answer
Laravel collection nth method
PHP Laravel
1 vote315 views2 answers
Insert batch in laravel
PHP Laravel
3 votes293 views4 answers
Laravel where has Relation
PHP Laravel
4 votes367 views1 answer
Laravel before migration
PHP Laravel