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 votes264 views3 answers
Crrate model in laravel
PHP Laravel
0 vote290 views1 answer
Set config key dynamic laravel
PHP Laravel
0 vote190 views1 answer
Laravel eloquent mass assignments
PHP Laravel
2 votes226 views3 answers
Laravel get file contents from storage
PHP Laravel
0 vote276 views1 answer
Take and skip in laravel
PHP Laravel
3 votes262 views1 answer
Laravel mail and sms system
PHP Laravel
2 votes283 views2 answers
Laravel migration two primary key
PHP Laravel
28 votes252 views6 answers
Laravel change column type
PHP Laravel
6 votes309 views6 answers
Laravel get current route name
PHP Laravel
0 vote274 views1 answer
Laravel select only one word from string
PHP Laravel