아래와 같은 쿼리가 있을때
WITH
menu_org( a,bc)
AS
(
SELECT a,b,c,d,e
FROM smt_0030
where a =''
union all
select a.a,a.b,b.c.b.d,b.e
FROM SMT_0030 a ,SMT_0040 b
where a.a = b.c and
a.b = b.d and
b.e >= '1'
)select a,b,c,d,e
order by a,b
-->>>>
위의 쿼리를 한번감싸서 다시 쿼리 할려면 어떻게 해야 하나요???
아래와 같이 하면 안되는데..
select * (
WITH
menu_org( a,bc)
AS
(
SELECT a,b,c,d,e
FROM smt_0030
where a =''
union all
select a.a,a.b,b.c.b.d,b.e
FROM SMT_0030 a ,SMT_0040 b
where a.a = b.c and
a.b = b.d and
b.e >= '1'
)select a,b,c,d,e
order by a,b
) as temp
|