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 vote210 views1 answer
Human readable date laravel
PHP Laravel
0 vote208 views1 answer
Function with parament php
PHP
0 vote178 views1 answer
Laravel return redirect by stuckOverFlow
PHP
21 votes244 views2 answers
Long text in laravel migration
PHP Laravel
8 votes211 views2 answers
Laravel Edit
PHP Laravel
63 votes180 views6 answers
Artisan cache clear
PHP
2 votes206 views1 answer
Laravel eloquent update pivot table
PHP
3 votes212 views3 answers
Php check if a url exists
PHP
17 votes238 views2 answers
Mysql replace a character in a string
PHP
4 votes217 views1 answer
Refresh a specific migration in laravel
PHP Laravel