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

3 votes167 views4 answers
Codeigniter apache remove index.php
PHP
-1 vote218 views2 answers
Laravel model save get id
PHP Laravel
0 vote190 views1 answer
Laravel login shows 404
PHP Laravel
1 vote204 views1 answer
Enablequerylog laravel
PHP Laravel
0 vote175 views1 answer
Wc php retrieve the order Id on Order pay page
PHP
3 votes172 views3 answers
Php replace space with dash
PHP
3 votes178 views2 answers
Laravel route multiple methods
PHP
0 vote216 views1 answer
Laravel collection max
PHP Laravel
3 votes175 views2 answers
Custom 404 page in laravel
PHP
6 votes263 views3 answers
How assign default value to laravel migration column
PHP