首页 文章

完整性约束违规:1052列和where子句不明确

提问于
浏览
0

我有两个表 Tbl_payroll_leave_employeev2tbl_payroll_leave_schedulev2 ,我想 join 他们但我得到这样的错误

SQLSTATE [23000]:完整性约束违规:1052列在where子句是不明确的 'payroll_leave_employee_id'(SQL:从tbl_payroll_leave_employee_v2内选择payroll_employee_id加入tbl_payroll_leave_schedulev2上tbl_payroll_leave_employee_v2.payroll_leave_employee_id = tbl_payroll_leave_schedulev2.payroll_leave_employee_id其中payroll_leave_employee_id = 5)◀

我的 table 结构
enter image description here

$employee_id = Tbl_payroll_leave_employeev2::select('payroll_employee_id')
   ->join('tbl_payroll_leave_schedulev2','tbl_payroll_leave_employee_v2.payroll_leave_employee_id','=','tbl_payroll_leave_schedulev2.payroll_leave_employee_id')
   ->where('payroll_leave_employee_id',$emp)
   ->get();

1 回答

  • 1

    在where条件中,您必须定义表 tbl_payroll_leave_employee_v2 或表 tbl_payroll_leave_schedulev2 的字段 payroll_leave_employee_id

    $employee_id = Tbl_payroll_leave_employeev2::select('payroll_employee_id')
       ->join('tbl_payroll_leave_schedulev2','tbl_payroll_leave_employee_v2.payroll_leave_employee_id','=','tbl_payroll_leave_schedulev2.payroll_leave_employee_id')
       ->where('tbl_payroll_leave_schedulev2.payroll_leave_employee_id',$emp)
       ->get();
    

相关问题