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
