Re: SQL query help!

From: Scott <scott_at_hcsprogramming.com>
Date: 19 Apr 2007 13:40:01 -0700
Message-ID: <1177015201.729794.288240@n59g2000hsh.googlegroups.com>

Michael,

I have tried that in several places and it is not allowed. Where should I put the where clause?

Thanks,
Scott

On Apr 19, 3:38 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Scott" <s..._at_hcsprogramming.com> a écrit dans le message de news: 1177010577.548816.316..._at_e65g2000hsc.googlegroups.com...
> | Hello,
> |
> | I am not very good with SQL and I was given this query that I do not
> | know how to limit it to one wbs_id. Can someone help?
> |
> | Thanks in Advance,
> | Scott
> |
> | SELECT LEVEL xlevel
> | ,proj_id
> | ,wbs_short_name
> | ,wbs_id
> | ,parent_wbs_id
> | ,SYS_CONNECT_BY_PATH(wbs_short_name,'.')
> | ,REVERSE(SYS_CONNECT_BY_PATH(REVERSE(wbs_short_name),'.'))
> | FROM admuser.projwbs
> | START WITH proj_id = 1356
> | CONNECT BY PRIOR parent_wbs_id = wbs_id
> |
>
> where wbs_id = <your wbs_id>
>
> Regards
> Michel Cadot
Received on Thu Apr 19 2007 - 15:40:01 CDT