Sorry about the non-descriptive subject, but I'm tired and really couldn't
think of a way to describe my question in one line <g>.
I have a database table of product information and a database table of
product category information. Each product may exist in more than one
category, so I created a "mappings" table that simply contains
ItemID-CategoryID pairs. This is all well and good.
I am trying to write a product details query that includes a comma delimited
list of the CategoryIDs that the product belongs to. Currently I run two
queries: one for the data from the product table and another for the
CategoryIDs from the mappings table. Then I create a list of the Category
IDs and manually add the list to the query of other product data.
Is there a way to get SQL to do this for me in one query? As far as I know
subqueries are only useful when they return a single value, which won't
quite work here. Any ideas?
Thanks in advance,
Seth Petry-Johnson
Argo Enterprise and Associates
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
