I have a authors table containing publicationsa_id a_fname a_lname I can concatenate the text with a_lname || '," || a_fname into the_name. I have a query that returns 3 rows, but I would like to have each of the rows have the concatenated text from all the rows in a column. For example,
"lastname1,firstcharacter1;lastname2,firstcharacter2;lastname3,firstcharacter3;" Is this doable? I'll keep looking to figure it out. thank you. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2820 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
