Hierarchical Queries w/ Join?

From: Lucas Tam <REMOVEnntp_at_rogers.com>
Date: 14 Feb 2002 13:11:04 -0600
Message-ID: <Xns91B58FDFD9DA8nntprogerscom@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:11:04 CST