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 vote157 views2 answers
Maatwebsite/excel package 5.2 laravel
PHP
3 votes154 views2 answers
What should write for getting extension of image in php
PHP
0 vote263 views2 answers
Yii2 set cookie
PHP Yii
2 votes183 views1 answer
Adding css to php file
PHP
4 votes140 views2 answers
Read json file data using php
PHP
23 votes164 views4 answers
Laravel carbon isoformat
PHP Laravel
2 votes200 views3 answers
Css php
PHP
0 vote168 views1 answer
How to stop message of laravel mix
PHP Laravel
5 votes145 views2 answers
Check if array value exists in another array php
PHP
7 votes150 views3 answers
Wp get post id by slug
PHP