Re: subquery as a table/view for other subqueries in the same complex query ?

Home -> Community -> Usenet -> c.d.o.misc -> Re: subquery as a table/view for other subqueries in the same complex query ?

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Mon, 27 Oct 2003 23:21:53 GMT
Message-ID: <lMhnb.19634$1C5.6583@nwrdny02.gnilink.net>

"Anna C. Dent" <anacdent_at_hotmail.com> wrote in message news:iMgnb.86842$Ms2.76926_at_fed1read03...
> Henry wrote:
>
> > If a complext have (say) 6 subqueries, I tried to make one as a
> > table/view for other subqueries in a complex query. I assume this will
> > avoid to query the same information for several times. But when
> > compling, it complains it can not find the table/view.
> >
> > Is it possible to use it this way?
>
> Yes, if done correctly.
>
> I'm curious.
> Exactly how does someone "compile" a table/view?

You would compile a view by

Alter view viewname compile;

Anurag Received on Mon Oct 27 2003 - 17:21:53 CST