Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5E8034759AF for ; Tue, 10 Dec 2002 07:26:16 -0500 (EST) Received: from [194.200.64.250] (unknown [194.200.64.250]) by postgresql.org (Postfix) with SMTP id ADDF8474E44 for ; Tue, 10 Dec 2002 07:26:14 -0500 (EST) Received: from cobalt.abcmail.co.uk by [194.200.64.250] via smtpd (for postgresql.org [64.49.215.8]) with SMTP; Tue, 10 Dec 2002 12:21:59 +0000 Received: from abcfw3.abcmail.co.uk (abcfw3.abcmail.co.uk [192.168.0.1]) by cobalt.abcmail.co.uk (8.10.2/8.10.2) with SMTP id gBACQnH20070 for ; Tue, 10 Dec 2002 12:26:49 GMT Received: from no.name.available by abcfw3.abcmail.co.uk via smtpd (for cobalt.abcmail.co.uk [192.168.0.9]) with SMTP; Tue, 10 Dec 2002 12:21:58 +0000 User-Agent: Microsoft-Entourage/10.1.0.2006 Date: Tue, 10 Dec 2002 12:27:34 +0000 Subject: SQL syntax for concating values in different rows together From: "Elizabeth O'Neill's Office Mail" To: Message-ID: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/111 X-Sequence-Number: 10699 Hi Can someone please help me. I have two tables in my database a complaint table and a resolution table. One complaint may have several resolutions. I am trying to build a report that will give me the complaint details and all the resolution descriptions for a complaint in one text area/row (concated together). At the moment it is repeating the complaint details for each resolution. Any help would be gratefully received Cheers Liz