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 vote177 views1 answer
Base64 encode username password php example
PHP
1 vote186 views2 answers
Redrectnh to https n laravel
PHP Laravel
0 vote175 views1 answer
Php regex strin start with
PHP
2 votes169 views1 answer
Laravel checkbox terms and conditions
PHP
2 votes192 views2 answers
Laravel valet 504 gateway time-out
PHP Laravel
2 votes168 views4 answers
Add 7 days to date php
PHP
2 votes215 views4 answers
Laravel redirect action
PHP
10 votes171 views2 answers
Get element by index array php
PHP
0 vote181 views1 answer
Php iterate through a loop
PHP
0 vote161 views1 answer
How do I test a website using XAMPP?
PHP