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 vote254 views1 answer
Tinker colorful
PHP
0 vote282 views1 answer
Php sort time
PHP
0 vote251 views1 answer
Get url segment in php
PHP
2 votes262 views4 answers
Pasar datetime a string php
PHP
0 vote257 views1 answer
How to get stripe processing fees api
PHP
4 votes307 views3 answers
Laravel eloquent remove from db
PHP Laravel
4 votes249 views2 answers
Read json file data using php
PHP
0 vote325 views1 answer
Laravel migration add contraint to other database
PHP Laravel
1 vote373 views1 answer
Migration create symfony
PHP Symfony
1 vote281 views1 answer
Wordpress get perma link
PHP Wordpress