SELECT question.

From: <plant.eng_at_lund.mail.telia.com>
Date: Thu, 16 Mar 2000 12:32:58 GMT
Message-ID: <38D0C64F.14B4820C@lund.mail.telia.com>

I have following problem:
Table DEPT columns DEPT_ID, DEPT_NAME
Table EMP, columns EMP_ID, EMP_NAME, DEPT_ID

I need to build a LOV listing employees ordered by department. I can easily build a view (record group) giving:

DEPT1 EMP1 DEPT1_ID EMP1_ID
DEPT1 EMP2 DEPT1_ID EMP2_ID
DEPT1 EMP3 DEPT1_ID EMP3_ID
DEPT2 EMP4 DEPT2_ID EMP4_ID
DEPT2 EMP5 DEPT2_ID EMP5_ID

What I want instead is:

DEPT1 EMP1 DEPT1_ID EMP1_ID
      EMP2 DEPT1_ID EMP2_ID
      EMP3 DEPT1_ID EMP3_ID
DEPT2 EMP4 DEPT2_ID EMP4_ID
      EMP5 DEPT2_ID EMP5_ID

Is there anyone who can give me a hint how to build a view like this or any reference, where I can find similar solution?

Thanks Tony. Received on Thu Mar 16 2000 - 06:32:58 CST