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

11 votes203 views6 answers
Php convert object to array
PHP
0 vote185 views1 answer
Remove % sign from string php
PHP
1 vote213 views2 answers
Wp_query custom post type
PHP
15 votes239 views3 answers
Laravel target class does not exist
PHP Laravel
0 vote185 views1 answer
File form validation codeigniter
PHP
2 votes204 views2 answers
How to restart php-fpm on ubuntu
PHP
2 votes215 views2 answers
If browser url is having query string after domain name in it check using php
PHP
0 vote185 views1 answer
Php round all values in array
PHP
8 votes213 views4 answers
Array flip php
PHP
1 vote201 views1 answer
How to change laravel 8 login credentials
PHP Laravel