Take a look at this, it’s beautifull the uses that can be found. http://it.toolbox.com/blogs/peoplesoft-pro/the-top-5-uses-for-connected-query-56756

My client wanted a simple Year-over-Year query that I could build in any query tool other than PSQuery. Now with Connected Query, the parent-child relationship creates just what was needed.