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 votes146 views1 answer
Proper permission webserver laravel
PHP Laravel
28 votes192 views12 answers
Laravel middleware
PHP Laravel
2 votes139 views2 answers
Laravel date default now
PHP Laravel
0 vote151 views1 answer
How to read laravel query string with dash
PHP Laravel
-1 vote137 views2 answers
Random number laravel faker
PHP Laravel
1 vote161 views1 answer
Laravel profile migration tool
PHP Laravel
0 vote136 views1 answer
Configuration laravel dompdf
PHP Laravel
0 vote139 views1 answer
Laravel 8 crud api example
PHP Laravel
0 vote127 views1 answer
Laravel datatable columnDefs
PHP Laravel
0 vote198 views1 answer
Laravel vu3
PHP Laravel