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 vote189 views1 answer
How to sort with array and after print by for loop in php
PHP
9 votes233 views2 answers
Laravel query count raw
PHP Laravel
0 vote194 views1 answer
Php version not update after windows env file
PHP
0 vote218 views1 answer
Php header filename with spaces
PHP
0 vote193 views1 answer
Php check if folder empty
PHP
1 vote274 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Seeder' not found
PHP Symfony
0 vote217 views1 answer
Php on page query
PHP
0 vote221 views1 answer
Get data from 2 table in response laravel
PHP
3 votes246 views1 answer
How to named route resource laravel
PHP Laravel
31 votes207 views6 answers
Php get client ip
PHP