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 vote172 views2 answers
How to set optional third parameter in routes of codeigniter
PHP CodeIgniter
0 vote126 views1 answer
Tax query by term id
PHP
0 vote84 views1 answer
Non utf-8 characters in php
PHP
1 vote125 views1 answer
Image uploading and validation php
PHP
1 vote163 views1 answer
Laravel eloquent get only field name
PHP Laravel
4 votes126 views3 answers
Install php7.4 linux
PHP
1 vote142 views1 answer
Laravel Unable to migrate or Make Seeds
PHP Laravel
-1 vote152 views1 answer
PHP Warning: require(/Applications/Ampps/www/SalesSystem/vendor/composer/../symfony/polyfill-php80/bootstrap.php): failed to open stream: No such file or directory in /Applications/Ampps/www/SalesSystem/vendor/composer/autoload_real.php on line 66
PHP Symfony
0 vote138 views1 answer
Veue laravel remove #/
PHP
0 vote123 views1 answer
Guzzlehttp submit form file
PHP