Forum Discussion
Solved
Join Table Man to Many
Hi guys,
I have a tire table like
Car table
| Car name | Tire Weight | Tire Width |
| Toyota | 100 | 10 |
| Honda | 200 | 10 |
| Mazda | 100 | 40 |
| A | 200 | 80 |
| C | 300 | 120 |
Tire table
| Product | Tire Weight | Tire Width |
| A | 100 | 10 |
| B | 100 | 10 |
| C | 100 | 40 |
| D | 200 | 80 |
| E | 200 | 80 |
The result should be
| Car name | Tire Weight | Tire Width | Produtct |
| Toyota | 100 | 10 | A |
| Toyota | 100 | 10 | B |
| Honda | 200 | 10 | |
| Mazda | 100 | 40 | C |
| A | 200 | 80 | D |
| A | 200 | 80 | E |
| C | 300 | 120 |
Basically is a left join it it has many to many relation ship. Bem label in the right has more products with the key Tire Weight and Tire Widht, it will duplicate the product in the left table.
Any ideas?
Thanks
