SAPDB seems to supports the SQL3 WITH RECURSIVE construct (that you can also find in DB2) that is stronger than the limited simple table "connect" construct in Oracle. Hope it works as advertised. Google for "WITH RECURSIVE", "transitive closure" and/or SQL3 Starting point http://www-db.stanford.edu/~ullman/fcdb/spr99/lec13.pdf (you find it similar in the garcia/ullman/widom book.)
Regards Wolf N�cker Dan Fitzpatrick <[EMAIL PROTECTED]> schrieb am 23.02.02: > Does SAPDB support selecting a tree structure like Oracle? > > select LEVEL, EMPNO, ENAME, MGR > from EMP > connect by prior EMPNO = MGR > start with MGR is NULL; > > If not, what is the best way to pull out a tree structure? > > Thanks, > > Dan > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general ________________________________________________________________ Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr! Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
