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 vote200 views6 answers
Use varable on all site pages laravel
PHP Laravel
0 vote230 views1 answer
Server error in laravel
PHP Laravel
1 vote235 views1 answer
Laravel migration add datetime column with default
PHP Laravel
0 vote239 views1 answer
Laravel where doesn't have
PHP Laravel
8 votes229 views1 answer
If any error in blade laravel
PHP Laravel
7 votes240 views3 answers
Get table name from model laravel
PHP Laravel
0 vote219 views3 answers
Method put laravel
PHP Laravel
0 vote212 views1 answer
Scribe laravel
PHP Laravel
0 vote221 views1 answer
Laravel signed Route custom domain
PHP Laravel
6 votes233 views4 answers
Laravel set config
PHP Laravel