MySQL: Select one of each option cartesian product -


i have table like

product name     option type     option value                color           red                color           green                size            m                size            l 

now need list of possible option combinations, i.e.

product name     options                              color: red, size: m                color: red, size: l                color: green, size: m                color: green, size: l 

is doable in mysql?


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -