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

0 vote287 views1 answer
Laravel 8 - get values of url query strings in controller
PHP Laravel
15 votes221 views3 answers
Laravel target class does not exist
PHP Laravel
0 vote225 views1 answer
Populate old value of dropdown laravel
PHP Laravel
7 votes207 views3 answers
Laravel creat new model
PHP Laravel
0 vote215 views1 answer
Laravel observer check if field changed
PHP Laravel
8 votes228 views2 answers
Store file into specific directory laravel using storage facade
PHP Laravel
-1 vote216 views3 answers
Delete rows by migration laravel
PHP Laravel
0 vote245 views1 answer
Laravel ID Generator
PHP Laravel
0 vote206 views1 answer
How to find the name of login user in laravel
PHP Laravel
7 votes221 views2 answers
Laravel seeder with relationships
PHP Laravel