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

25 votes161 views6 answers
Laravel where
PHP
0 vote208 views1 answer
Laravel telescope redirect to localhost
PHP Laravel
0 vote156 views1 answer
Symfony refresh endpoints
PHP
0 vote162 views1 answer
0 == "string" php
PHP
0 vote154 views1 answer
Install phpredis MAC OSX
PHP
4 votes195 views2 answers
Add class to body class wordpress
PHP Wordpress
0 vote200 views2 answers
Transient wordpress
PHP
2 votes162 views1 answer
Merubah judul menjadi slug codeigniter
PHP
1 vote163 views2 answers
How to pass parameter in routes of laravel
PHP
0 vote155 views1 answer
Check the existing image in s3 laravel
PHP