Hi Everyone,
We created table using below code and its working
with Table_A AS
(select C1,c2,C3,C4,C5,C6..
from
(select C1,C2,C3,C4
from
(select C1,C2,
from Table_B B,Table_C C
)))
select B.c1,B.c2,C.C4,C.C5
from Table_A,Table_B B,Table_C C
Now we are trying to create View on top of the above query we used below syntax.
create or replace view V1 as
(
with Table_A AS
(select C1,c2,C3,C4,C5,C6..
from
(select C1,C2,C3,C4
from
(select C1,C2,
from Table_B B,Table_C C
)))
select B.c1,B.c2,C.C4,C.C5
from Table_A,Table_B B,Table_C C
)
select * from Table_A;
getting below error can someone suggest.
