Basing a T-List Item on a record group

From: wozi <wozi_at_dhc.net>
Date: Mon, 13 Dec 1999 19:40:49 -0800
Message-ID: <00C9C09315C38902.832294850CD4E93F.5462CCD6734E8244_at_lp.airnews.net>



Hi everyone,

Using the scott.dept table, I have created a record group which looks like the following in the T-List item.

10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON My question is to how structure the sql statement so that it looks like this:

10      ACCOUNTING     NEW YORK
20      RESEARCH        DALLAS
30      SALES                 CHICAGO
40     OPERATIONS      BOSTON

Thanks for the help. Received on Tue Dec 14 1999 - 04:40:49 CET

Original text of this message