Re: Informix 4gl Query

How do you acomplish this in SQL Server? Chucho! -----Original Message----- From: gary.cobden@nhs.net (Gary Cobden) To: informix-list@iiug.org Date: 10 Sep 2004 07:57:45 -0700 Subject: Informix 4gl Query Whilst I have a MS SQL background, I need assistance with the following please:- I have a table with the following structure:- customer_id; text_line_number; text_info Each customer_id can have several records, each with a different text_line_number I need to consolidate all the records in a new table so that there is one record for each customer_id and the text_info fields are consolidated eg:- customer_id 7777; text_line_number 1; text_info abc; customer_id 7777; text_line_number 2; text_info def; becomes - in the consolidated record customer_id 7777; text_info abc def; Any assistance would be appreciated Thanks Gary Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com sending to informix-list