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 vote99 views1 answer
Apache use public folder as root
PHP
0 vote95 views1 answer
How do I get a YouTube video thumbnail from the YouTube API?
PHP
6 votes95 views2 answers
Php artisan key generate
PHP
1 vote100 views1 answer
Php header to another page
PHP
4 votes114 views5 answers
Add csrf token laravel
PHP Laravel
1 vote148 views1 answer
The token has been blacklisted laravel jwt
PHP Laravel
0 vote129 views2 answers
Wordpress move debug.log
PHP Wordpress
1 vote111 views3 answers
Get page title wordpress
PHP Wordpress
1 vote101 views1 answer
Add shortcode in short description
PHP
1 vote160 views1 answer
Lumen jwt
PHP