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 vote276 views1 answer
How to import in laravel excel command
PHP Laravel
0 vote287 views2 answers
Laravel retain old value
PHP Laravel
2 votes294 views1 answer
Laravel mix purge css
PHP Laravel
0 vote281 views2 answers
Laravel 8 query builder, Left Join / Right Join Clause
PHP Laravel
0 vote262 views1 answer
Laravel model insert multiple
PHP Laravel
1 vote296 views1 answer
Laravel select all except some columns
PHP Laravel
0 vote282 views1 answer
Optimize clear laravel not working
PHP Laravel
3 votes285 views2 answers
Laravel check if query builder is empty
PHP Laravel
35 votes263 views6 answers
Laravel db query
PHP Laravel
8 votes298 views4 answers
Laravel between dates
PHP Laravel