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

26 votes250 views4 answers
Where is cache file in laravel
PHP Laravel
4 votes235 views2 answers
Laravel pass variables to view
PHP Laravel
0 vote288 views1 answer
Laravel import data from csv
PHP Laravel
2 votes250 views2 answers
Get session id in laravel
PHP Laravel
0 vote260 views2 answers
Laravel log could not be opened fix
PHP Laravel
1 vote230 views1 answer
Integer default value laravel
PHP Laravel
50 votes273 views6 answers
Laravel database seeder
PHP Laravel
0 vote241 views2 answers
How to separate date and time in laravel
PHP Laravel
37 votes267 views6 answers
Laravel create or update
PHP Laravel
3 votes189 views2 answers
Laravel migration on delete set null
PHP Laravel