Creating View WITH clause Issue

User_JZKI6

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.

James Su

The view logic doesn't make sense. Anyway you should remove the parentheses after "as".