Hi, I have the following data:
mysql> select Dealername,pc from ford_gb where pc='LE4 7SL'; +-----------------------------+---------+ | Dealername | pc | +-----------------------------+---------+ | CD Bramall Ford - Leicester | LE4 7SL | | CD Bramall Ford - Leicester | LE4 7SL | | CD Bramall Ford - Leicester | LE4 7SL | +-----------------------------+---------+ Is there a way in a single SQL query to group by Dealername, and have the postcodes concatenated into a comma-separated list? e.g. +-----------------------------+----------------------------+ | Dealername | concat_pc | +-----------------------------+----------------------------+ | CD Bramall Ford - Leicester | LE4 7SL, LE4 7SL, LE4 7SL | +-----------------------------+----------------------------+ Running MySQL 4.1 on Fedora C3. Any help appreciated, Andrew SQL, Query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]