Re: cannot have subqueries in CONNECT BY clause

Alexander V. Silantiev doodled thusly:

>There are (sketchy):

kool. I'll give it a go tomorrow at work. Late Monday night here now.

>
>create or replace view classify_rview as
>select cid,cmaster from classify f
>where exists(select null from classifyrw where cid=f.cid and
>username=user);

wouldn't

select a.cid,a.cmaster
from classify a, classifyRW b
where a.cid = b.cid
and b.username = user

be exactly the same? And no sub-query...

anyways, will have another go at it in the morning.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Mon Nov 19 2001 - 06:13:23 CST