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

0 vote132 views2 answers
Laravel filemanger choose multiple images
PHP Laravel
6 votes145 views3 answers
Laravel blade route redirect back
PHP Laravel
0 vote145 views1 answer
Artisan laravel require bootstrap
PHP Laravel
0 vote131 views2 answers
How to get just the first row from a table in laravel
PHP Laravel
1 vote84 views1 answer
Forelse in laravel
PHP Laravel
1 vote135 views1 answer
Array_last in laravel 8
PHP Laravel
0 vote137 views1 answer
Laravel view not created using foreign keys
PHP Laravel
0 vote128 views1 answer
Token delete laravel
PHP Laravel
6 votes137 views3 answers
Laravel ide helper
PHP Laravel
6 votes120 views1 answer
Laravel scaffolding
PHP Laravel