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

1 vote189 views1 answer
Tackle discount in php laravel blade
PHP Laravel
8 votes186 views3 answers
Laravel date between
PHP Laravel
1 vote183 views1 answer
Laravel storage check file exists
PHP Laravel
0 vote175 views1 answer
Laravel sendgrid using 2 possible authenticators. Authenticator LOGIN returned Expected response code 250
PHP Laravel
0 vote181 views1 answer
Laravel face-auth
PHP Laravel
3 votes202 views1 answer
Sms laravel
PHP Laravel
0 vote191 views1 answer
Laravel auth without vue or bootstrap
PHP Laravel
0 vote174 views1 answer
Laravel collection forget
PHP Laravel
0 vote190 views1 answer
Custom timestamp column laravel
PHP Laravel
4 votes188 views2 answers
Laravel session forget
PHP Laravel