I believe you're describing a crosstab query. This should help you put it
On Friday, July 09, 2010 07:37:41 pm Phillip Baker wrote:
> Hello All,
> For the life of me I cannot remember how to make a query like this and what
> it is called.
> I know it is fairly basic though.
> Table 1
> Product_id Product_Name
> Table 2
> Category_id, Category_name
> Table 3
> Product_id, Category_id
> Each product can have one or more categories.
> So I want a result that has
> Product A one category other category
> Product B other category
> Thanks in advance.
> Blessed Be
> If you try to protect idiots from themselves, even if you succeed, you just
> wind up filling the world with idiots.
> - - Doug Casey