SELECT
A.*,B.*
FROM
(SELECT
STR_TO_DATE( CONCAT( "2021-06", '-', d ), '%Y-%m-%d' ) AS DATE
FROM
(
SELECT
1 AS d UNION ALL
SELECT
2 UNION ALL
SELECT
3 UNION ALL
SELECT
4 UNION ALL
SELECT
5 UNION ALL
SELECT
6 UNION ALL
SELECT
7 UNION ALL
SELECT
8 UNION ALL
SELECT
9 UNION ALL
SELECT
10 UNION ALL
SELECT
11 UNION ALL
SELECT
12 UNION ALL
SELECT
13 UNION ALL
SELECT
14 UNION ALL
SELECT
15 UNION ALL
SELECT
16 UNION ALL
SELECT
17 UNION ALL
SELECT
18 UNION ALL
SELECT
19 UNION ALL
SELECT
20 UNION ALL
SELECT
21 UNION ALL
SELECT
22 UNION ALL
SELECT
23 UNION ALL
SELECT
24 UNION ALL
SELECT
25 UNION ALL
SELECT
26 UNION ALL
SELECT
27 UNION ALL
SELECT
28 UNION ALL
SELECT
29 UNION ALL
SELECT
30 UNION ALL
SELECT
31
) AS d) A
LEFT JOIN
(SELECT
A.id,A.fk_model_id,A.duty_dates,A.duty_member_ids,B.squad_leader,B.user_night
FROM
ec_duty_model AS B
LEFT JOIN
(SELECT
*
FROM
ec_duty
WHERE
duty_dates IN (SELECT CONCAT('2021-06','-',help_topic_id +1) DAY
FROM mysql.help_topic
WHERE help_topic_id < DAY(LAST_DAY(CONCAT('2021-06','-1')))
ORDER BY help_topic_id)) AS A
ON A.fk_model_id = B.id AND B.is_delete = 0 AND A.is_delete = 0) AS B
ON DATE = B.duty_dates
这是报错信息