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

4 votes156 views1 answer
Know php file name
PHP
22 votes186 views6 answers
Where like in laravel
PHP Laravel
5 votes192 views3 answers
Laravel blade for if
PHP
0 vote141 views1 answer
Get last name user
PHP
1 vote200 views4 answers
Dynamic base url codeigniter
PHP CodeIgniter
1 vote164 views2 answers
Set postman global variable header
PHP
0 vote154 views1 answer
Php artisan spark not working in codeigniter
PHP
0 vote171 views1 answer
Search line phpstorm mac
PHP
1 vote276 views3 answers
Symfony datetime now
PHP Symfony
0 vote154 views2 answers
Upload video in laravel
PHP