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

15 votes252 views6 answers
Add shortcode in wordpress
PHP
13 votes210 views4 answers
Laravel migration remove column
PHP
1 vote258 views3 answers
Convert date to timestamp in laravel builder
PHP Laravel
2 votes224 views1 answer
Get number of chars ina string php
PHP
0 vote229 views6 answers
Update codeigniter
PHP
0 vote222 views1 answer
Handling deadlocks laravel
PHP
3 votes259 views1 answer
Wordpress query orderby name
PHP Wordpress
0 vote218 views1 answer
Wordpress check if page is password protected
PHP
6 votes232 views1 answer
Warning illegal string offset
PHP
15 votes201 views3 answers
Php strtoupper
PHP