Re: Multiple Record Query

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Mon, 07 Jan 2002 13:39:18 GMT
Message-ID: <ayh_7.21173$Sf2.202679@rwcrnsc52>

Given your description how does one know one row from another. One could just as easily end up with:

 part_no          description
 TM611TXV         Line two of text, Line one of text, Line three
                  of text, Line four of text

or does order not matter?
Jim

"Nick Heppleston" <nickheppleston_at_gmx.co.uk> wrote in message news:150151d5.0201070408.12c21ce2_at_posting.google.com...
> Any help would be much appreciated on the following query - i don't
> have a clue where to start!!!
>
> I have a table where multiple records have the same product part
> number.
>
> e.g.
>
> part_no description
> TM611TXV Line one of text,
> TM611TXV Line two of text,
> TM611TXV Line three of text,
> TM611TXV Line four of text,
>
> I want to take each record with the same part number and concatenate
> them into one record which is returned from the query.
>
> resulting in:
>
> part_no description
> TM611TXV Line one of text, Line two of text, Line three
> of text, Line four of text
>
>
> The only problem is that there could be 1 or 20+ records that need to
> be concatenated - it needs to work it out on the fly.
>
> Thanks for your time on this matter, Nick
Received on Mon Jan 07 2002 - 07:39:18 CST