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

2 votes314 views3 answers
PHP executable not found. Install PHP and add it to your PATH or set the php.executablePath setting in linux
PHP
25 votes297 views6 answers
Calculate the Difference Between Two Dates Using PHP
PHP
0 vote267 views1 answer
Validate unique or equal
PHP
8 votes270 views2 answers
Laravel hash namespace
PHP
12 votes256 views3 answers
Update composer php version
PHP
0 vote289 views1 answer
How to download file from s3 bucket using php
PHP
11 votes279 views4 answers
Laravel validator make custom message
PHP Laravel
1 vote284 views1 answer
Tackle discount in php laravel blade
PHP
0 vote269 views1 answer
Get count of relationship table laravel
PHP
0 vote282 views1 answer
Laravel target is not instantiable while building
PHP