yuyanyanbobo
不应该啊,用下面的语法试试,假设员工姓名为nameSELECT c.*,emp.name create_name,em.name due_name FROM chance cINNER JOIN employee_info AS emp ON c.create_id=emp.employeeIdINNER JOIN employee_info AS em ON c.due_id=em.employeeId WHERE c.chanceId=16
优质英语培训问答知识库