如题,感谢。
SELECT teach.sk_skxq , teachers_xm AS '教师姓名', SUM(lessons.kc_ks) AS '课时和' FROM (lessons INNER JOIN teach ON lessons.kc_code = teach.sk_kcm) INNER JOIN teachers_info ON teachers_info.teachers_jgh =teach.sk_jgh GROUP BY teachers_info.teachers_xm ,teach.sk_skxq;