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 votes225 views1 answer
Codeigniter select for update
PHP CodeIgniter
0 vote173 views1 answer
Php $_POST contains
PHP
0 vote211 views1 answer
Laravel check if relationship has data
PHP Laravel
0 vote252 views3 answers
Php find multiple value in array
PHP
0 vote172 views1 answer
How to make core controller codeigniter 3 more than 1
PHP
5 votes185 views3 answers
Globals in php
PHP
0 vote336 views1 answer
Php code to display a div with background fade
PHP
3 votes183 views1 answer
Wordpress get domain
PHP
8 votes164 views6 answers
Codeigniter echo last query
PHP
0 vote153 views2 answers
Wp revisions config
PHP