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 vote160 views1 answer
Create symbolic in lumen laravel
PHP Laravel
0 vote186 views1 answer
<warning>PHP Warning: preg_grep() expects parameter 2 to be array, string given in G:\Office Projects\Luggage Backend\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Concerns \Guards Attributes.php on line 207</warning>
PHP Laravel
2 votes164 views2 answers
Laravel migration two primary key
PHP Laravel
1 vote151 views2 answers
Database//Eloquent//Model.php laravel errror array t- string conversion
PHP Laravel
1 vote190 views1 answer
What is lang in laravel
PHP Laravel
0 vote150 views2 answers
Laravel return 1 as true
PHP Laravel
3 votes178 views6 answers
Last insert id in laravel
PHP Laravel
39 votes159 views6 answers
Laravel foreign key constraint
PHP Laravel
1 vote163 views3 answers
How to create controller in specific folder laravel
PHP Laravel
1 vote158 views1 answer
How to return data in json format in laravel
PHP Laravel