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 vote135 views1 answer
Get input data in php
PHP
4 votes174 views2 answers
How to rename a table element in laravel
PHP Laravel
2 votes148 views2 answers
How to do laravel in sidebar active menu dynamic blade
PHP
-1 vote150 views1 answer
Wordpress add comments programmatically
PHP
0 vote186 views1 answer
->sale_price
PHP
28 votes244 views12 answers
Laravel middleware
PHP Laravel
0 vote126 views1 answer
En php comment convertir une date en français stackoverflow
PHP
10 votes208 views6 answers
Php redirect to another page
PHP
11 votes163 views3 answers
Remove package in laravel
PHP Laravel
6 votes162 views4 answers
Woocommerce get product category name by id
PHP