sql join for three tables in laravel 5.3

Question

I want to join three tables in laravel 5.3.I want to join three table and fetch approver name and department name

table travel_request
id
approver_id (fk)
department_id (FK) 

user table
approver_id
name

Department table
department_id 
dept_name

query
 $users = DB::table('travel_request')
        ->join('department', 'travel_request.department_id', '=', 'department.department_id')
        ->join('users', 'travel_request.department_id', '=', 'users.approver_id')
        ->select('travel_request.*', 'department.name as dept_name','users.name as approver_name')->get();

Mahfuzul Alam · Accepted Answer · 2016-10-06 09:17:17Z

2

You use ->join('users', 'travel_request.department_id', '=', 'users.approver_id')

It should be

$users = DB::table('travel_request')
    ->join('department', 'travel_request.department_id', '=', 'department.department_id')
    ->join('users', 'travel_request.approver_id', '=', 'users.approver_id')
    ->select('travel_request.*', 'department.name as dept_name','users.name as approver_name')->get();

answered Oct 6, 2016 at 9:17

Mahfuzul Alam

3,17716 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

sql join for three tables in laravel 5.3

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