Home » SQL & PL/SQL » SQL & PL/SQL » how to use joins in hierarchical queries (11g)
how to use joins in hierarchical queries [message #612287] Tue, 15 April 2014 10:37 Go to next message
ashwanth77
Messages: 94
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

Re: how to use joins in hierarchical queries [message #612288 is a reply to message #612287] Tue, 15 April 2014 10:53 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2071
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.
Re: how to use joins in hierarchical queries [message #612291 is a reply to message #612287] Tue, 15 April 2014 11:31 Go to previous message
Michel Cadot
Messages: 58852
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:
  


Current Time: Thu Aug 21 05:31:49 CDT 2014

Total time taken to generate the page: 0.05240 seconds