Hi there,
I'm stuck in trying to connect two tables. The first one is a database looking like the following:
| SKU | Category | Season | Color | Size |
| 1 | Shirts | Spring/summer | Red | M |
| 2 | Shirts | Fall/Winter | Blue | M |
| 3 | Jackets | Spring/Summer | Yellow | L |
The second one contains information on campaigns that are run based on certain criterias applicable to some or all the above:
| Campaign | Category | Season | Color | Size |
| -20% on Spring/Summer Shirts | Shirts | Spring/summer | *any* | *any* |
| -10% on Red Jackets | Jackets | *any* | Red | *any* |
Consider we have 50+ Campaigns but each SKU should be on only one campaign at a time (has to be validated). How can associate the Campaign to each SKU in table 1?
Thanks,
Daniele
