> 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, I agree that it's often better to point someone in the right direction rather than just writing the query for them, but in this case it was a newbie question. From where I saw it, the difficulty was in concatenating values from 2 rows, not the concatenation itself. That is why I thought your response was not sufficient. Apologies if I caused any offense. --Rob ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]