The only way I know to get a relational database to output a comma-delimited list is to use a cursor. |-------------------+-----------------------------------------------------| |Eric A. Laney |"We have seen too much success to have become | |Systems Engineer |obsessed with failure." | |LAN Optimization | | |Team | | |Verizon Data | Lyndon B. Johnson (1908-1973)^Quoted in National| |Services | Review, 31 December 1963| |Voice: 813.978.4404| | |Pager: 888.985.8519| | | | | |-------------------+-----------------------------------------------------|
"Yanik
Lupien" To: SQL <[EMAIL PROTECTED]>
<yanikl@visic cc:
.com> Subject: SQL List
2001-09-27
09:46
Please
respond to
sql
Hi,
I have a small question.
This is my table :
English French
-------- --------
Dog Chien
Dog Pitou
Cat Chat
Cat Minou
Animal Animal
I want something like : Select English, XXXX(French) from table group by
English : to get a list of "French"
English French
-------- --------
Dog Chien, Pitou
Cat Chat, Minou
Animal Animal
It is possible ?
Yanik Lupien
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
