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

-1 vote137 views1 answer
How to create a tryit editor
PHP
3 votes146 views2 answers
Order number generate laravel
PHP Laravel
15 votes164 views6 answers
Install laravel
PHP Laravel
1 vote133 views1 answer
None of the supported PHP extensions (PgSQL, PDO_PgSQL) are available.
PHP
0 vote138 views1 answer
Diffforhumans laravel
PHP
0 vote145 views1 answer
Display picture in pdf generated with laravel
PHP
0 vote148 views3 answers
Laravel sync with attributes
PHP
-2 votes202 views2 answers
Why we use pusher in laravel
PHP Laravel
33 votes127 views6 answers
Laravel carbon
PHP
9 votes204 views3 answers
Show all validation errors in laravel's blade view
PHP Laravel