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.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.