Retrieving 4 records as 1 record

From: <Abeeda_Mohammed_at_xn.xerox.com>
Date: Tue, 26 May 1998 14:48:19 GMT
Message-ID: <6kekni$qs3$1@nnrp1.dejanews.com>

Hello,

I have a table with the following fields :

Order_no,
Order_followup_no,
orderstatus

If the records in the table are

Order#      Order_followup#     Orderstatus
1               101                         PLACED
1                102                        RECIVED
1                103                        ANSWERED
1                104                        COMPLETE
2                 101                       PLACED
2                  102                      RECEIVED
2                   103                      ANSWERED
2                    104                    COMPLETE

I want to create a view which displays

1 PLACED RECEIVED ANSWERED COMPLETE
2 PLACED RECEIVED ANSWERED COMPLETE How do I do this?

Thank you,

Abeeda

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 26 1998 - 09:48:19 CDT