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 vote303 views1 answer
Nova laravel image
PHP Laravel
4 votes237 views2 answers
Laravel collection random
PHP
0 vote248 views1 answer
How to merge 2 laravel eloquent records
PHP
2 votes241 views1 answer
Install composer without requirement
PHP
2 votes239 views5 answers
Maximum execution time of 30 seconds exceeded
PHP
18 votes257 views10 answers
Stackoverflow
PHP
0 vote240 views1 answer
Php header deny
PHP
3 votes256 views1 answer
Php exercises
PHP
15 votes246 views4 answers
Remove space from start and end of string in php
PHP
0 vote207 views1 answer
Php integer to js integer
PHP