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 vote387 views2 answers
Faker image laravel 8
PHP Laravel
0 vote281 views1 answer
Laravel validation not equal to
PHP Laravel
1 vote327 views3 answers
Check image exist or not in laravel
PHP Laravel
0 vote347 views1 answer
Laravel Testing send raw data in GET method
PHP Laravel
0 vote289 views1 answer
Laravel validation on gropu route
PHP Laravel
2 votes287 views3 answers
Laravel 8 404 status
PHP Laravel
0 vote322 views1 answer
Laravel has many limit
PHP Laravel
0 vote287 views2 answers
Socket io laravel
PHP Laravel
1 vote305 views2 answers
Laravel check collection has key
PHP Laravel
0 vote306 views1 answer
Numeros positivos input laravel
PHP Laravel