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 votes127 views1 answer
Laravel model truncate
PHP Laravel
0 vote149 views1 answer
Onclick call route laravel
PHP Laravel
0 vote133 views1 answer
Skip model accessor laravel8
PHP Laravel
0 vote138 views1 answer
Laravel use variable inside callback function
PHP Laravel
24 votes141 views6 answers
Laravel create model
PHP Laravel
1 vote125 views1 answer
Laravel plural
PHP Laravel
24 votes141 views4 answers
Laravel query not null
PHP Laravel
0 vote143 views1 answer
Laravel share on whatsapp link
PHP Laravel
7 votes130 views6 answers
Laravel validation unique email
PHP Laravel
0 vote146 views2 answers
Faker image laravel
PHP Laravel