SELECT m.phoneNumber,m.course,m.source,m.mobileArea,m.age,m.sex,m.regTime,d.mac, GROUP_CONCAT(d.lessonName) AS lname
FROM downloadrecord d LEFT JOIN(SELECT * FROM mobileuser ORDER BY id DESC)AS m ON d.mac=m.mac
AND d.mac='8C-7B-9D-F0-6A-3D' GROUP BY d.mac
1:LEFT JOIN ON
左连接,将左边表所有记录全部列出,如果右边表对应的记录有值则将记录值列举出来
2:LEFT JOIN ON子查询
LEFT JOIN(SELECT * FROM mobileuser ORDER BY id DESC)AS m ON
如果右边表符合条件的记录有两个,则取ID最大的那个
3:GROUP_CONCAT(d.lessonName)......GROUP BY d.mac根据d.mac进行组合查询,同事对lessonName字段进行连接显示为一个字段lname