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 vote186 views2 answers
Fillable vs guarded laravel
PHP Laravel
0 vote204 views2 answers
Laravel migration change column order
PHP Laravel
0 vote185 views1 answer
How to call function in blade laravel
PHP Laravel
0 vote184 views2 answers
Laravel form put method
PHP Laravel
2 votes215 views2 answers
Laravel validate form data unique
PHP Laravel
8 votes182 views1 answer
Laravel store link
PHP Laravel
-1 vote168 views2 answers
Laravel 5.6 orderby
PHP Laravel
2 votes168 views1 answer
Global laravel request()
PHP Laravel
0 vote205 views1 answer
How to get yearly chart in laravel
PHP Laravel
0 vote192 views1 answer
Array of dates laravel
PHP Laravel