how to join query different table in laravel

Question

I try to join three tables which are named attendances, categories, and users. my code is

 $Attendance= DB::table('users')
     ->join('categories','users.U_category_id', '=', 'categories.id')
     ->select('users.*','categories.batch_name')->get();

but I also need to join attendances table where attendances column User_A_ID and users table id are the same. How can I do this?

Al Amin · Accepted Answer · 2021-02-06 05:18:55Z

1

You can try it with

$Attendance= DB::table('users')
            ->join('categories','users.U_category_id', '=', 'categories.id')
            ->join('attendances','users.id', '=', 'attendances.User_A_ID')
            ->select('users.*','categories.batch_name')->get();

answered Feb 6, 2021 at 5:18

Al Amin

1501 gold badge1 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to join query different table in laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related