Strange Join needed...

Hello all,

I have a question:

I have a primary table A that is joined to several one-to-many tables B and C.  

A normal join will give me the following:

   SELECT A.field1, A.field2, B.field3, C.field4    FROM A, B, C
   WHERE A.key_id = B.key_id and

         A.key_id = C.key_id

    A.field1 A.field2 B.field3 C.field4

• --------- --------- --------- Smith John aaa ddd Smith John aaa eee Smith John bbb ddd Smith John bbb eee Smith John ccc ddd Smith John ccc eee

How can I get a result more like this:

    A.field1     A.field2     B.field3        C.field4
    ---------    ---------    ---------       ---------
    Smith        John         aaa, bbb, ccc   ddd, eee

This is preferred in that it will be less rows to send to my client app.

Any help is appreciated.

Thanks,

Manash Sahoo. Received on Thu Oct 27 1994 - 22:31:42 CET