OraFAQ Forum: SQL & PL/SQL » how to use joins in hierarchical queries

Home » SQL & PL/SQL » SQL & PL/SQL » how to use joins in hierarchical queries (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to use joins in hierarchical queries [message #612287]

Tue, 15 April 2014 10:37

ashwanth77
Messages: 95
Registered: April 2013
Location: India

Member

how to use joins in hierarchical queries

SELECT cust_id AS child_id
           FROM customer c,cust_assoc_dnorm d on d.dsend_id=c.cust_id
          WHERE connect_by_isleaf=1  and
           LEVEL = 6
          START WITH cust_id = 12660
         CONNECT BY PRIOR cust_id = cust_cust_id

Report message to a moderator

Re: how to use joins in hierarchical queries [message #612288 is a reply to message #612287]

Tue, 15 April 2014 10:53

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Since you did not post what you tried, I just have a clue for you. Make your required table join data as inner query and try again.

Report message to a moderator

Re: how to use joins in hierarchical queries [message #612291 is a reply to message #612287]

Tue, 15 April 2014 11:31

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

how to use joins in hierarchical queries

In the proper way, as much as possible.

[Updated on: Tue, 15 April 2014 11:32]

Report message to a moderator

Previous Topic:	ORA-29283: invalid file operation
Next Topic:	Create table in sqlplus script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 09:06:26 CDT 2024