CREATE VIEW bm_jifen_all_view
AS
SELECT a.id, a.gname, b.zj
FROM bumen a
LEFT OUTER JOIN (SELECT SUM(jifen) AS zj, R_bm
FROM mybox
WHERE iscls = 0
GROUP BY bm) b
ON a.id = b.bm;
AS
SELECT a.id, a.gname, b.zj
FROM bumen a
LEFT OUTER JOIN (SELECT SUM(jifen) AS zj, R_bm
FROM mybox
WHERE iscls = 0
GROUP BY bm) b
ON a.id = b.bm;
AS
SELECT a.id, a.gname, b.zj
FROM bumen a
LEFT OUTER JOIN (SELECT SUM(jifen) AS zj, R_bm
FROM mybox
WHERE iscls = 0
GROUP BY bm) b
ON a.id = b.bm;
还是一样的错误哦
可以这样:
先创建视图v1,create view v1 as
SELECT SUM(jifen) AS zj, bm, R_bm FROM mybox WHERE iscls = 0 GROUP BY bm;再用包含子查询的视图v1create view v2 as
SELECT a.id, a.gname, b.zj
FROM bumen a
LEFT OUTER JOIN v1 as b
ON a.id = b.bm;
create view a
as
SELECT SUM(jifen) AS zj, R_bm FROM mybox WHERE iscls =0 GROUP BY bm
---再创建视图b,后在与视图a做连接
create view b as
SELECT a.id, a.gname, b.zj
FROM bumen m
LEFT OUTER JOIN a as n
ON m.id = m.bm;