虑而后能得

select group_name,COUNT(group_id) ,sex,school_year,batch_no ,grade_noFROM tp_group INNER JOIN tp_group_student ontp_group.id = tp_group_student.group_id GROUP BY group_id原本洋洋洒洒一大篇文章，结果被被弄没了，所以我很愤...

如题我最近要用到三个表联合查询，所以干脆就做个整理，写下这个常用的sql语句语句SELECT A.student_code, A.student_name, A.class_name,B.exam_name, B.start_time, B.end_time, C.student_score FROM ( A LEFT JOIN B ON A.examination_id = B...