Querying Information

Posted in 1993

RUCHI@CFRVM.CFR.USF.EDU — Wed, 24 Feb 93 11:44:05 EST — source: Informix-list mailing list archive (1991-1998)

I have a table that defines the nodes structures and want to generate the tree structure style of the report using SQL statement. If this is not possible, any suggestions would be helpful. Data looks like: node = 181 nodlevel = PRESIDENT superior = 0 node = 182 nodlevel = VICE PRESIDENT superior = 181 node = 183 nodlevel = GENERAL COUNSEL superior = 181 node = 184 nodlevel=PURCHASING superior = 182 I want the report to look like following: PRESIDENT VICE PRESIDENT PURCHASING GENERAL COUNSEL Please let me know If I can do this using Ace report. Thanks. Ruchi