> > T_Cat
> > 100 Toaster
> > 200 Roaster
> >
> > T_Product
> > 1 Generic Toaster
> > 2 GE Toaster 3000
> >
> > T_ProdCat
> > 1 100
> > 2 100
> > 2 200
>
> Interesting idea. But "no subproduct specified" isn't exactly the same
> thing as "Generic". For instance, retrieve all of the orders without
> any subproduct specified.
This recent thread titled "How to represent category, subcategory,
product" may be helpful:
http://groups.google.com/group/comp.databases.theory/browse_frm/thread/884a0a00ae42a0f5/#
Received on Wed Jan 10 2007 - 09:40:34 CST
