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

2 votes298 views2 answers
The requested url was not found on this server. laravel
PHP
4 votes323 views5 answers
Laravel array_pluck
PHP Laravel
0 vote367 views2 answers
Global variable in laravel controller
PHP Laravel
0 vote359 views1 answer
Upgrade php linux
PHP
1 vote350 views2 answers
How to use custom domain name on localhost on linux ubuntu
PHP
0 vote354 views1 answer
Download file using jquery php
PHP
1 vote366 views1 answer
Twig limit text
PHP
0 vote330 views1 answer
Php add 1 day hours to unix timestamp
PHP
3 votes350 views1 answer
Laravel send post request from controller
PHP
0 vote375 views1 answer
Drupal 7 db_query example
PHP