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 vote262 views1 answer
Laravel request integer
PHP
2 votes350 views1 answer
Laravel scout import command
PHP Laravel
35 votes310 views6 answers
For loop php
PHP
0 vote319 views1 answer
Laravel first or with callback
PHP
6 votes309 views1 answer
Php quit
PHP
9 votes344 views3 answers
Show all validation errors in laravel's blade view
PHP Laravel
0 vote338 views1 answer
Form validation for file type in codeigniter
PHP CodeIgniter
0 vote299 views1 answer
Eager loading in hasmany belongsto relationship
PHP
4 votes338 views1 answer
Create view from route laravel
PHP Laravel
1 vote311 views1 answer
Declare boolean php
PHP