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 vote140 views2 answers
Fetch data based on month and year in laravel
PHP Laravel
7 votes147 views4 answers
With message in laravel
PHP Laravel
0 vote130 views1 answer
Laravel password require one letter and one number
PHP Laravel
2 votes114 views3 answers
Laravel get file size uploaded
PHP Laravel
0 vote172 views1 answer
Laravel target is not instantiable while building
PHP Laravel
2 votes129 views2 answers
Laravel pagination with get parameters
PHP Laravel
0 vote136 views3 answers
Laravel 7 upload file s3
PHP Laravel
0 vote125 views1 answer
Select max id laravel
PHP Laravel
2 votes130 views1 answer
Add Laravel .env variable to Vue component
PHP Laravel
2 votes124 views1 answer
Laravel catch exception ex log save
PHP Laravel