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 votes107 views5 answers
Laravel installation in windows
PHP
0 vote163 views1 answer
Comment ajouter un fil d’Ariane personnalisé à l’URL d’accueil dans WooCommerce
PHP
0 vote60 views0 answer
PHP
0 vote109 views1 answer
No cache on browser back php
PHP
7 votes104 views2 answers
Laravel field types from database field type
PHP
3 votes147 views6 answers
Email verification laravel
PHP
0 vote178 views1 answer
Inner pages not found yii
PHP Yii
0 vote128 views3 answers
Laravel query order by relation
PHP Laravel
0 vote160 views1 answer
Drupal 9 loop term objects to retrieve term data (id, name, uuid)
PHP Drupal
0 vote130 views1 answer
Diffforhumans laravel
PHP Laravel