mysql having in_mysql – ‘having子句’中的未知列

如文档中所述

The SQL standard requires that HAVING must reference only columns in the GROUP BY clause or columns used in aggregate functions. However, MySQL supports an extension to this behavior, and permits HAVING to refer to columns in the SELECT list and columns in outer subqueries as well.

您必须在select子句中指定return_date和rental_date.

有两种选择：

SELECT DISTINCT

customer.first_name,

rental.return_date,

rental.rental_date

FROM

rental,

customer

WHERE

rental.customer_id = customer.customer_id

GROUP BY

rental.rental_id

HAVING

(

rental.return_date - rental.rental_date

) =(

...

要么

SELECT DISTINCT

customer.first_name,

(rental.return_date - rental.rental_date) as rental_duration

FROM

rental,

customer

WHERE

rental.customer_id = customer.customer_id

GROUP BY

rental.rental_id

HAVING

rental_duration =(

...

两者都应该工作得很好.