SQL question / Multiple rows output in one line

From: dirk <dirk_at_acker.com>
Date: 5 Nov 2003 10:23:19 -0600
Message-ID: <3fa923f7_1_at_127.0.0.1>


How can I do this?

Table A

A B


John      New York
John      Miami
John      ...
Max       London

I want to do a SELECT which outputs

John, New York Miami ... in one Line

How can I do this?
Can

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed Nov 05 2003 - 17:23:19 CET

Original text of this message