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 votes238 views2 answers
How login one user with id in laravel
PHP Laravel
0 vote232 views2 answers
Laravel event listener
PHP Laravel
1 vote220 views1 answer
Laravel validate enum field
PHP Laravel
0 vote215 views3 answers
Laravel has many deep
PHP Laravel
0 vote207 views1 answer
Laravel schedule kernel code sample
PHP Laravel
3 votes241 views2 answers
{{Str::limit laravel
PHP Laravel
0 vote242 views2 answers
Show query in laravel
PHP Laravel
7 votes227 views4 answers
UUIDs LARAVEL
PHP Laravel
1 vote232 views2 answers
Laravel collection flatten
PHP Laravel
0 vote214 views1 answer
How push to array whit key in laravel
PHP Laravel