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 vote132 views1 answer
Internal server error phpmyadmin
PHP
8 votes105 views4 answers
In_array()
PHP
0 vote121 views1 answer
Laravel array in lang
PHP
0 vote128 views1 answer
Prevent re submit form
PHP
0 vote183 views1 answer
Script to create AdminLTE in a Laravel project
PHP Laravel
1 vote147 views2 answers
Scheduling in laravel in custom cron
PHP Laravel
0 vote149 views1 answer
Access-control-allow-origin php laravel
PHP Laravel
15 votes128 views3 answers
Laravel make model with migration 5.8
PHP
0 vote156 views1 answer
Run xampp application on windows startup
PHP
1 vote124 views1 answer
Laravel env google smtp
PHP