> Okay then, let's take this one step further.... > > If my DB has 2 table (many to one), such as product---<options linked on > product ID. > > Can anyone think of a way to create a view that will show the > option row for a given productid as a single delimited list? Not in SQL in one Query - I now understand what you wanted. SQL thinks more in rows, it'd be nice if a sub-query could be used in the SELECT part and product a comma separated list. If you're only looking for one item with ProductIDs attached, then you can use ValueList() to return the list, but if it's for multiple items, with their relevant productIDs attached to their rows, then I don't think there's an easy way to return this. Sorry Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
