All:
I have the following table
key data
1 'Version 1'
1 'Version 2'
1 'Version 3'
2 'Version 4'
2 'Version 5'
(obviously key is not primary)
I want to write a query that returns
key data
1 'Version 1 Version 2 Version 3'
2 ' Version 4 Version 5'
Basically I want a row returned for each unique key, but i want the
data column for each key (string data) concatenated together (and
seperated with spaces if possible :) ).
Thanks,
Rich Rattanni
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
