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 vote142 views1 answer
Laravel get relation camelcase api
PHP Laravel
0 vote120 views1 answer
Php rce command
PHP
1 vote111 views1 answer
Codeigniter where date interval
PHP
0 vote133 views1 answer
Codeigniter remote queries very slow
PHP
3 votes115 views1 answer
Php exercises
PHP
0 vote125 views1 answer
Add auth middleware to route laravel
PHP Laravel
-2 votes108 views4 answers
Laravel get ID from insert
PHP
0 vote156 views1 answer
How to set 1 year date without saturday in while loop php
PHP
1 vote137 views1 answer
Php array merge skip diplicate
PHP
5 votes148 views3 answers
Laravel grouping where
PHP Laravel