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 vote275 views1 answer
How check if variable is resgister in laravel
PHP
3 votes205 views2 answers
Php rand vs mt_rand
PHP
4 votes293 views3 answers
How to create an associative array in php
PHP
0 vote230 views1 answer
Rest api response 404 wordpress
PHP Wordpress
0 vote175 views1 answer
Can we use 2 select in a query laravel
PHP
0 vote178 views1 answer
Where date laravel
PHP
2 votes156 views2 answers
Php set environment variable
PHP
0 vote175 views1 answer
Remove non-uppercase character php
PHP
0 vote131 views1 answer
Session() in lumen
PHP
8 votes342 views5 answers
Redirect in codeigniter
PHP CodeIgniter