I have one master table and a detail table. How can I get all the rows in the detail table for a perticular key in the master table int o a single row. For Eg

Master
-------
key date
1 1-jan-03


detail
------
key date desc
1 1-jan-03 description1
1 1-jan-03 description2



The result should be
------------------------------------
1 1-jan-03 description1 description2



Thanks in advance
Santhosh