可以的哦。CREATE VIEW tt AS SELECT * FROM (SELECT * FROM tb)T
create view viw_snapshot_cost as select tmp.clk_id as sss_id, sum(tmp.cost) as cost from tbl_snapshot as s join ( select DISTINCT(c.cst_id), l.clk_id, c.cst_cost as cost from tbl_costlink as l join tbl_cost as c on l.cst_id=c.cst_id ) as tmp on tmp.clk_id=s.sss_idgroup by clk_id 数据库报错,说view 包含子查询
AS
SELECT * FROM (SELECT * FROM tb)T
select tmp.clk_id as sss_id, sum(tmp.cost) as cost
from tbl_snapshot as s
join (
select DISTINCT(c.cst_id), l.clk_id, c.cst_cost as cost
from tbl_costlink as l
join tbl_cost as c on l.cst_id=c.cst_id
) as tmp on tmp.clk_id=s.sss_idgroup by clk_id
数据库报错,说view 包含子查询