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

11 votes134 views5 answers
Laravel model transaction
PHP
5 votes140 views3 answers
Get result count codeigniter
PHP
0 vote114 views1 answer
Ipv6 pregmatch
PHP
4 votes164 views2 answers
Laravel eloquent get data without duplicates
PHP Laravel
0 vote140 views1 answer
Bitnami lightsail PHP Fatal error: Out of memory (allocated
PHP
1 vote142 views1 answer
Linux nohup write other file
PHP
0 vote135 views1 answer
Group where conditions in laravel
PHP
0 vote151 views1 answer
Add bootstrap class to checkout fields woocommerce
PHP
0 vote131 views1 answer
Laravel array search blade
PHP
3 votes139 views6 answers
Failed to open stream: Permission denied
PHP