我如何這條sql語句做成視圖:
with aa as(
.........
),bb as(
........
)
select * from bb
這樣會報錯,如何把with的語句做成視圖?
create view v_test
as
with aa as(
.........
),bb as(
........
)
select * from bb
------解决方案--------------------
没报错,你具体语句是怎样的?
没报错,你具体语句是怎样的?