arthur.sw Asked: 2021-01-15 06:44:42 +0800 CST 在 MySQL 中为子查询使用别名时,“where 子句”中的未知列 1 这个简单的查询: select exam.id as exam_id, (select count(*) from dataset where dataset.id = exam.id) as n_dataset from exam where n_dataset = 0 返回以下错误: ERROR 1054 (42S22) at line 1: Unknown column 'n_dataset' in 'where clause' 为什么? mysql where