not a crystal related

[unknownly]

Hi Guys,

It's not really a crystal report problem. Can I get any help with the SQL Query(Oracle) Please.

I have pull the data form the following tables(eg
SUB,OWN,ELIM,NODE
-where a Node unit is the upper most level and then
-Elim unit and Own unit are on same level(and a node will have only one elim unit).
-Sub unit are last level are owned by Own unit's
Trick part is :

If a sub unit's and own unit's earliest common Node unit's immediate child will be the Elim unit.

Iam able to do the SUb and Own part but Iam not able to do th elim part.

driving table would be the Node. I know Iam not very clear in explaining but I hope you get what Iam trying to say..

really need any help I can get..


Thanks,
Sweetie

 

[Turkbear]

Hi,
First: Post in the Oracle: related forums here(see below).
Second: When you do that, give full Version and OS details, and give an example of what the output would look like. ( giving the metadata about the tables and their relationships will also be a good idea)
Oracle 9:
forum759
Oracle 8:
forum186

 

[unknownly]

Thank you. I will post in the right forum.