>> 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. >And therefore it's most important that he tries to learn how to look at >the doc. Remembering my own troubles learning MySQL, it can be difficult to know *what* to search for - if this person is completely new to SQL, the concept of joining a table to itself might not occur.
>Or your newbies will start asking every shit on List because the don't >know what to do else. I know, it is annoying answering questions just because someone can't be bothered. >> 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. >Well it was to be exact concating 2 tables with their rows. >Well your post was also not sufficient, because you didn't helped him at >all, too. Yes, I know my post didn't answer the question either :) I mailed because I thought you might've misunderstood the original question and thought it was just about how to concatenate two strings, rather than the more difficult joining part. --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]