Re: SQL Q: Concatenate multiple rows on same column.

[Roger Baklund]

* Roger Baklund
[...]
> SET @a="";
> SELECT @a:=CONCAT(@a,' ',long_desc) FROM YourTable;
> SELECT @a;

Sorry, my test table only contained records for a single product... you
would need something like this:

SELECT @a:=CONCAT(@a,' ',long_desc)
  FROM YourTable
  WHERE pn = "HL1450"
  ORDER BY seq;

I don't know how to combine this with GROUP BY and ORDER BY.

--
Roger



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]