Hello there,
I have a question regarding the possibility of creating a string from a
resultset directly using an SQL command. I'm not sure if this is possible.
Here is what I have:
A table with links between articles and category in a catalog.
For ArticleID #1, I have say 3 categories, and I would like the list of
categories like that : 57,42,36
So I was trying to do something like that :
SELECT Concat_WS(',', (SELECT CatID FROM tblcatarticles WHERE ArticleID = 1))
But it obviously won't work since the subquery returns more than 1 row. My
question is : is there anyway to do this in one request or do I have to
browse my recordset and build my list using my favorite programming tool ?
Thanks!
HMax
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
