I have three tables as below: Table 1: attributes fields: attID, att_CategoryID, name Table 2: att_Category fields: att_CategoryID, name Table 3: prodcutAttributes fields: ID, productID, attID, I desigining this tables to be able to add multiple prodcut attributes for ecommerce site. I don't know how good this design is. Anyways I need to find out the sql command which can first see how many type of options are entered for the particular prodcut based on that, i need to get each product options entered for the prodcut. example: prodcut 1 might have att_category (COLOR): attributes( blue, black, green) and att_category(Size): attributes (xxl, xl, large) prodcut 2 might have only att_category(SIZE): attributes(large, medium, small) I would appreciate any help on this.
January 21, 2011 4:20 PM
January 27, 2011 3:02 PM