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

0 vote314 views1 answer
Trying to get property 'id' of non object in laravel api
PHP
0 vote324 views1 answer
Php adding options from an array
PHP
0 vote373 views1 answer
Onclick call route laravel
PHP
0 vote349 views3 answers
Laravel migration softdelete
PHP
0 vote333 views1 answer
Get post by name wordpress
PHP
14 votes332 views2 answers
Pass php object to javascript
PHP
12 votes537 views6 answers
Email validation in laravel
PHP
0 vote309 views2 answers
Laravel db insert get last id
PHP
0 vote338 views1 answer
Laravel validation get failed rules
PHP Laravel
1 vote446 views1 answer
Laravel pagination publish command
PHP Laravel