This was asked a few weeks ago on the SQL list ... here is the thread ... http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=256 &forumid=6&refresh=0
Dan -----Original Message----- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 12:13 PM To: CF-Talk Subject: OT - MS SQL help Is it possible to join two tables, and have a list of keys returned from one of the tables as a column of a recordset? tblOnePK | name 1 | threeFriends tableTwoPK | tblOneFK 1 | 1 2 | 1 3 | 1 And the record set should be: tblOnePK | name | listOfKeys 1 | threeFriends| 1,2,3 Make sense? I could do it programmatically in CF, but would like to pull this in one query and avoid a recordset/requery loop. Also, can't use a stored proc, unfortunately. Thanks for any help. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
