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 vote223 views1 answer
Is php the fucking worst
PHP
0 vote214 views1 answer
Php ajax registration form validation
PHP
0 vote225 views2 answers
Php polymorphism
PHP
0 vote237 views1 answer
Httpclient add authorization header symphony
PHP
19 votes246 views2 answers
PHP auto refresh page
PHP
0 vote245 views1 answer
Get return value from another function laravel
PHP Laravel
0 vote217 views1 answer
How to create compomemt in laravel livewire
PHP
5 votes221 views2 answers
Laravel auth namespace
PHP
21 votes238 views3 answers
Check array has keys in php
PHP
40 votes231 views4 answers
How to split string into array php
PHP