如果这段代码在PHPMyAdmin SQL上运行,我会做什么查询:
SELECT
DATE_FORMAT(d.date, '%b %e %Y') date,
u.employee_id, ai.time_in,
ao.time_out
FROM (SELECT date FROM hris_timein UNION SELECT date FROM hris_timeout order by date asc) d
CROSS JOIN hris_users u
LEFT JOIN hris_timein ai ON u.employee_id = ai.employee_id AND ai.date = d.date
LEFT JOIN hris_timeout ao ON u.employee_id = ao.employee_id AND ao.date = d.date输出:见输出
但是,当我在我的项目中使用这个代码时,它会显示一个错误:
Error description Unknown column 'd.date' in 'on clause'发布于 2022-08-18 06:45:25
该查询看起来正确,请使用引用的标识符进行尝试。
SELECT
DATE_FORMAT(d.`date`, '%b %e %Y') `date`,
u.`employee_id`,
ai.`time_in`,
ao.`time_out`
FROM
(
SELECT
`date`
FROM
`hris_timein`
UNION
SELECT
`date`
FROM
`hris_timeout`
) d
CROSS JOIN
`hris_users` u
LEFT JOIN
`hris_timein` ai
ON u.`employee_id` = ai.`employee_id` AND ai.`date` = d.`date`
LEFT JOIN
`hris_timeout` ao
ON u.`employee_id` = ao.`employee_id` AND ao.`date` = d.`date`;https://stackoverflow.com/questions/73398400
复制相似问题