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

11 votes364 views3 answers
Laravel get last month records
PHP Laravel
4 votes374 views3 answers
Laravel return json header json
PHP Laravel
0 vote384 views1 answer
Dynamic modal name appending in laravel
PHP Laravel
1 vote477 views1 answer
Laravel mongodb delete
PHP Laravel
1 vote352 views2 answers
Set nav link active on the basis of route laravel
PHP Laravel
0 vote346 views1 answer
Laravel Filesystem chmod(): Operation not permitted
PHP Laravel
0 vote340 views1 answer
Laravel get next and previous record
PHP Laravel
4 votes343 views1 answer
Laravel validation numeric vs integer
PHP Laravel
0 vote380 views1 answer
Laravel/framework[v7.29.0, ..., 7.x-dev] require ext-mbstring * -> it is missing from your system. Install or enable PHP's mbstring extension.
PHP Laravel
4 votes365 views3 answers
Laravel eloquent remove from db
PHP Laravel