Laravel join 2 tables eloquent

Join 2 tables laravel

use Illuminate\Support\Facades\DB;

$users = DB::table('users')
            ->join('contacts', 'users.id', '=', 'contacts.user_id')
            ->join('orders', 'users.id', '=', 'orders.user_id')
            ->select('users.*', 'contacts.phone', 'orders.price')
            ->get();

Source: laravel.com

Join multiple tables in laravel eloquent

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
            ->where('users.status', 'active')
            ->where('posts.status','active')
            ->get(['users.*', 'posts.descrption']);

Laravel join 2 tables eloquent

 $select->joinSub(
                    $selectSubQry,
                    'ag',
                    'ag.id',
                    '=',
                    'agp.userId'
                );

Similar codes

0 vote165 views1 answer
Php curl async callback
PHP
1 vote203 views3 answers
How to create controller in specific folder laravel
PHP Laravel
0 vote169 views1 answer
+ php quantifer
PHP
0 vote166 views1 answer
<a href="<?php echo base_url(); ?>">somelink</a>
PHP
0 vote263 views1 answer
Comment faire en sorte que le numéro de téléphone ne soit pas un champ obligatoire dans WooCommerce
PHP
46 votes226 views5 answers
Add column migration laravel
PHP Laravel
33 votes153 views6 answers
Laravel make:auth
PHP
0 vote174 views1 answer
Cakephp find_in_set
PHP CakePHP
1 vote171 views2 answers
How to make a child theme in wordpress
PHP
0 vote288 views2 answers
Undefined index token in get_request_headers
PHP