|
#2
Kendy1234562007-05-17 09:11
|
select a1._name as 电影, a1._date as 日期 --此句有误
from movies as a1, movies as a2
where a1._name =a2._name and a1._date <> a2._date
group by a1._name
服务器: 消息 8120，级别 16，状态 1，行 18
列 'a1._date' 在选择列表中无效，因为该列既不包含在聚合函数中，也不包含在 GROUP BY 子句中。