0

I get a caller, callee path from a table by using a CONNECT BY query.

Then using the result, I get info which is in another table so, I use left join.

When I use left join, I used callee as a condition. At this case, the root node's info is missed. Is there any good way to add root info, without using, union or subquery?

Jonathan Eustace
  • 2,469
  • 12
  • 31
  • 54
Ui-Gyun Jeong
  • 143
  • 1
  • 4
  • 14

0 Answers0