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 vote323 views2 answers
Laravel collection search by value
PHP Laravel
1 vote246 views1 answer
Twig json_encode
PHP
2 votes257 views1 answer
Laravel catch exception ex log save
PHP
1 vote247 views1 answer
Routing code in drupal 8
PHP
0 vote317 views1 answer
How to display the site tagline in wordpress
PHP Wordpress
0 vote243 views1 answer
Dot after each character php
PHP
0 vote245 views1 answer
Content for php.ini created manually
PHP
1 vote249 views2 answers
Php bulk insert mysql
PHP
0 vote303 views1 answer
If browser url is having domain name in it check using php
PHP
0 vote276 views1 answer
Laravel 8 Factory - One To Many (Polymorphic) Relationship
PHP