polkadot (2/25/2013)
SQL_Enthusiast,I double and triple checked the book and the WHILE query in my original post is a facsimile.
The where clause condition is slightly different, it excludes o1.supervisor<>o1.employee. The JOIN is on o1.employee=o2.supervisor. I'm not sure if that makes a difference....
I didn't notice the post above before. Is the code you most recently posted an exact duplicate of Ken's code or not?
--Jeff Moden
Change is inevitable... Change for the better is not.