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 vote173 views1 answer
Mac os down upgrade php version
PHP
1 vote164 views1 answer
Laravel s3 presigned url
PHP
0 vote190 views1 answer
Laravel collection pull
PHP
0 vote138 views1 answer
Shipping classes woocommerce
PHP
0 vote180 views1 answer
This behaviour is (currently) not supported by Doctrine 2
PHP
3 votes183 views2 answers
Destroy php variable
PHP
0 vote223 views2 answers
Search string inside array of objects php
PHP
100 votes193 views6 answers
Check if string contains character php
PHP
1 vote195 views1 answer
How create page 419 in laravel
PHP Laravel
1 vote229 views3 answers
Wp site url link from admin
PHP Wordpress