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

8 votes109 views4 answers
Array flip php
PHP
0 vote132 views3 answers
Rust zola vuejs
PHP
0 vote102 views1 answer
Store as real file name laravel uplaod
PHP
0 vote114 views2 answers
Maatwebsite/excel package 5.2 laravel
PHP
3 votes112 views1 answer
Get post info in php
PHP
0 vote103 views1 answer
Add brackets to string php
PHP
3 votes106 views3 answers
Class 'App\Http\Controllers\Auth' not found
PHP
0 vote142 views1 answer
How to add recaptcha validation in php
PHP
1 vote77 views1 answer
Composer require laravel/ui not working laravel 8
PHP Laravel
0 vote164 views2 answers
Customizing The Validation Attributes
PHP