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.fatherc.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
估计是mysql不支持这么复杂的多次嵌套sql
|