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

2 votes128 views1 answer
Laravel get only relationship
PHP Laravel
0 vote115 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP Laravel
6 votes110 views4 answers
Unique check with multiple columns laravel validation
PHP Laravel
4 votes110 views1 answer
How to check query execution time in laravel
PHP Laravel
0 vote104 views2 answers
Laravel validation exact string length
PHP Laravel
0 vote104 views1 answer
How to put external file in laravel listener class
PHP Laravel
1 vote136 views1 answer
Edit data using model in laravel 8
PHP Laravel
46 votes156 views6 answers
Add new column in existing table in laravel migration
PHP Laravel
0 vote105 views1 answer
Trying to access variable outside laravel collection
PHP Laravel
1 vote112 views2 answers
Upload a pdf file laravel
PHP Laravel