I have three tables as below: Table 1: options fields: optionsID, optionsCatID, name
Table 2: optionCat fields: optionsCatID, name
Table 3: prodcutOptions fields: pID, optionsID, prodcutID
I designed this tables for multiple prodcut options 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 COLOR: blue, black, green and Size: xxl, xl, large prodcut 2 might have only SIZE: large, medium, small prodcut 3 might have only COLOR: green, yellow, black
I would appreciate any help on this.