My company uses an AS400 as the main server with many, many other servers including SQL 2005. We are still primarily on XP because many of us require the "green-screen"...

I have found the answer. In case someone else has a similar problem, here is the SQL.

- Update the Long extra description from FKITEXTD Added by Joan

UPDATE U

SET U.CUMEXT =...

Thank you, but I do not want the line # in Table 2. I want to concatenate the extra descriptions from the 2 records in Table1 and update the 1...

Thank you, but it is a bit more complicated than that. I have 2 tables.

table 2 ...

I, too, have a similar problem., and am new to SQL. I have a DB2 file coming from an AS400 that has PART, Line#, and a text description.

AS400 file...