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

1 vote296 views1 answer
How to check exist in array in rule validation laravel
PHP Laravel
53 votes367 views6 answers
Laravel make seeder
PHP Laravel
0 vote279 views1 answer
Laravel project htaccess redirect to public path
PHP Laravel
8 votes278 views2 answers
Laravel passport
PHP Laravel
3 votes264 views1 answer
Laravel throw function
PHP Laravel
1 vote273 views1 answer
Convert php array to javascript json laravel
PHP Laravel
1 vote270 views1 answer
Integer default value laravel
PHP Laravel
0 vote259 views1 answer
Confiruando passaport no laravel
PHP Laravel
1 vote291 views2 answers
Fillable vs guarded laravel
PHP Laravel
0 vote252 views1 answer
Laravel lazy loading
PHP Laravel