Hi all,

Been a long time since I've been on.... hope everyone's well...

I' trying to do a select and concatenate and seem to have a bit of a brain block at the moment and was wondering if somebody can assist.

I have a table [table 1] which has a varchar(255) column, I need to update another table [table 2] with the info from this table but table 1 can have up to 2 entries that would form the single update that is required in to table 2...
ie, Item ABZ has 2 entires where as item ZXC has one..

Column 1 Column 2 Column 3
ABZ 5196744 Text 1
ABZ 5196744 Over flow of Text1
ZXC 9876543 Text 2


I would like to end up with
ABZ 5196744 Text 1 Over flow of Text1
ZXC 9876543 Text 2

Can any one point me is the right direction...?

Any comments would be great,