标题: View's SELECT contains a subquery in the FROM clause [打印本页] 作者: liyihongcug 时间: 2006-12-06 17:11 标题: View's SELECT contains a subquery in the FROM clause delimiter\\
CREATE view v_my_CityAdVisitCount AS
SELECT SUM(visit_count) AS visit_count, city
FROM (SELECT SUM(a.visit_count) AS visit_count, c1.city AS city
FROM city c, advisit_cpcityday a, city c1
WHERE c.cityid = a.cityid AND (c.father = c1.cityid) AND (c.father <> c.cityid)
GROUP BY c1.city
UNION
SELECT SUM(a.visit_count) AS visit_count, c.city AS city
FROM city c, advisit_cpcityday a
WHERE c.cityid = a.cityid AND (c.father = 0)
GROUP BY c.city
UNION
SELECT SUM(a.visit_count) AS visit_count, c.city AS city
FROM city c, advisit_cpcityday a
WHERE c.cityid = a.cityid AND c.father = c.cityid
GROUP BY c.city) t
GROUP BY city;
上面提示错误
View's SELECT contains a subquery in the FROM clause