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

0 vote152 views1 answer
Check string length is greater than 0 php
PHP
18 votes158 views3 answers
Php try json decode and check
PHP
0 vote168 views1 answer
Laravel observer check if field changed
PHP
0 vote152 views1 answer
How do i use $variables as values in php 7 mysqli insert
PHP
0 vote127 views1 answer
How to store multiple value in session in laravel
PHP Laravel
7 votes173 views2 answers
Wordpress get post type
PHP Wordpress
0 vote166 views1 answer
Cors error angular php
PHP
4 votes152 views5 answers
Laravel storage
PHP
0 vote148 views2 answers
Rearrange array index php
PHP
0 vote149 views1 answer
String replace smarty
PHP