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

9 votes148 views3 answers
Laravel image validation
PHP Laravel
13 votes129 views3 answers
Laravel string
PHP Laravel
3 votes151 views1 answer
Laravel firstOrFail
PHP Laravel
0 vote136 views1 answer
Laravel withValidator
PHP Laravel
7 votes162 views4 answers
UUIDs LARAVEL
PHP Laravel
1 vote99 views1 answer
Behamin brequest installation on laravel
PHP Laravel
2 votes137 views1 answer
Attach multiple files in laravel mailable
PHP Laravel
14 votes147 views3 answers
How to convert string to int in php laravel
PHP Laravel
0 vote145 views1 answer
Laravel collection union
PHP Laravel
4 votes156 views4 answers
Laravel add request
PHP Laravel