mysql一对多取最新的一条

最新推荐文章于 2024-05-08 23:48:40 发布

等等邓灯

最新推荐文章于 2024-05-08 23:48:40 发布

阅读量474

点赞数

分类专栏：软件文章标签： mysql 数据库

本文链接：https://blog.csdn.net/qq_39908911/article/details/127360652

版权

软件专栏收录该内容

3 篇文章 0 订阅

订阅专栏

SELECT
table1.*,
table2.expiration_time expirationTime
FROM
(
SELECT
stu.id student,
wo.id woId,
wo.created,
wo.summary,
wo.last_follow_up,
nl.teacher_id
FROM
wo_work_order wo
LEFT JOIN student stu ON wo.student_id = stu.id
LEFT JOIN new_lesson nl ON nl.id = wo.lesson_id
WHERE
wo.category IN ( ‘complaint_processing’, ‘lesson_quality_complaint’ )
AND wo.created > ‘2022-08-16 00:00:00’
AND wo.created < ‘2022-8-22 00:00:00’
AND stu.classification = ‘ECL’
AND stu.role <> ‘VIRTUAL’
AND stu.teaching_center IN ( ‘TC-XA’, ‘TC-WH’, ‘TC-CS’, ‘TC-BJ’, ‘NOT-SETTING’ )) table1
LEFT JOIN ( SELECT student_id, MAX( expiration_time ) expiration_time FROM sim_account GROUP BY student_id ) table2 ON table1.student = table2.student_id