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 vote380 views2 answers
Asset function in laravel not working
PHP Laravel
1 vote327 views1 answer
Check if cookie exists php
PHP
0 vote397 views1 answer
Laravel access request in provider
PHP Laravel
18 votes325 views6 answers
Php unix timestamp to date
PHP
0 vote343 views1 answer
Get lat long from google maps php
PHP
12 votes319 views3 answers
Uninstall php ubuntu
PHP
0 vote353 views1 answer
Request update password laravel
PHP Laravel
15 votes348 views2 answers
Check homebrew version
PHP
3 votes444 views1 answer
Laravel Auth Redirect based on role
PHP Laravel
1 vote317 views2 answers
Wp get meta field value
PHP