在laravel 5.3中，三个表的SQL连接 - sql join for three tables in laravel 5.3

sql join for three tables in laravel 5.3

本文关键字：三个连接 SQL laravel | 更新日期: 2023-09-27

我想在laravel 5.3中连接三个表。我想连接三个表并获取审批人名称和部门名称

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();

您使用->join('users', 'travel_request.department_id', '=', 'users.approver_id')

应该是

$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();