SELECT question

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 Wed Mar 15 2000 - 11:24:43 CET