SELECT *,SUM(tuanke_time.time) AS total_time
FROM `tuanke_time`
LEFT JOIN tuanke_student ON tuanke_student.Sid = tuanke_time.studentID
WHERE total_time > 100
GROUP BY tuanke_time.studentID
total_time is the alias you get for SUM(tuanke_time.time). The database table field itself does not have this column. total_time 是你给SUM(tuanke_time.time)取得别名,数据库表字段本身没有这列吧。
查询total_time > 100
Query total_time > 100, you can try it🎜🎜
🎜
SELECT *
FROM `tuanke_time`
LEFT JOIN tuanke_student ON tuanke_student.Sid = tuanke_time.studentID
GROUP BY tuanke_time.studentID having SUM(tuanke_time.time) > 100;
total_time
is the alias you get forSUM(tuanke_time.time)
. The database table field itself does not have this column.total_time
是你给SUM(tuanke_time.time)
取得别名,数据库表字段本身没有这列吧。查询
total_time > 100
total_time > 100
, you can try it🎜🎜 🎜Total_time is defined in the query output column. This column does not exist in the original table.
On and where in outer joins are equivalent and cannot be repeated. Just remove where