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

6 votes201 views6 answers
Search query in laravel
PHP Laravel
1 vote283 views3 answers
Queue jobs in laravel
PHP Laravel
0 vote245 views1 answer
Laravel one session per user
PHP Laravel
1 vote199 views1 answer
Laravel query get big table records
PHP Laravel
13 votes238 views5 answers
How to change validation message in laravel
PHP Laravel
7 votes222 views2 answers
Laravel 8 query builder, Inner Join Clause
PHP Laravel
-1 vote186 views4 answers
Laravel collection find
PHP Laravel
13 votes269 views6 answers
Find auth laravel
PHP Laravel
10 votes236 views6 answers
Laravel Pagination
PHP Laravel
1 vote266 views1 answer
Laravel eloquent get only field name
PHP Laravel