Tuesday, May 22, 2012

Two Foreign Keys in one Column. How to split?

I have the following situation.



Combinations Table:

Combination ID | Option ID's


Options Table:

Option ID | Option Name | Option Value



The "Option ID's" column in the combinations table reads like "2345,3421" (in the one column) when refering to the two options associated to the combination.



Is it possible to generate a list that lists all possible combinations and values for each combination?



ie. combination1 | option1 | name:size | value:Small | option2 | name:color | value:Blue





No comments:

Post a Comment