Re: Hierarchical Queries w/ Join?

Nevermind, Found an article here on how to do it:

http://www.arrowsent.com/oratip/tip40.htm

Lucas Tam <REMOVEnntp_at_rogers.com> wrote in news:Xns91B58FDFD9DA8nntprogerscom_at_63.209.170.233:

> Hi,
>
>
> Is there a way to do Hierarchical Queries w/ Joins?
>
>
> I need to merge data from two tables based on a parent child
> relationship.
>
> I could run multiple selects, BUT I need to order the final data.
>
> Any suggestions? Stored Procedures are out of the question as I don't
> have access to that...
>
> This select is targeted towards the web... so something fast would be
> nice.
>
>
> Tables look like this:
>
> Table A
> =======
> ChildID
> ParentID
>
>
> Table B
> =======
> TestID
> TestName
> ChildIDFromTableA
> Description
>
> I need to order by TestName in table B.
>
>
> TIA.
>
Received on Thu Feb 14 2002 - 13:46:17 CST