Rob Desbois schrieb:
To those who responded - read the question. He wants to combine the values from the data column of *2* rows into one, not just a straightforward string concatenation.
Sorry but you want me to write the whole SQL query? He has to use his brain. Grouping and joining the tables. I'm not here for doing your or his work! Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]