I have two tables like this (mysqli):
Products
| ID | Product |
|---|---|
| 1 | Product No.1 |
| 2 | Product No.2 |
| 3 | Product No.3 |
Grade
| ID | Grade |
|---|---|
| 1 | grade 1 |
| 2 | grade 2 |
| 2 | grade 3 |
I need to combine each row in table Products to all row in table Grade and result is like this:
| Product | Grade |
|---|---|
| Product No.1 | grade 1 |
| Product No.1 | grade 2 |
| Product No.1 | grade 3 |
| Product No.2 | grade 1 |
| Product No.2 | grade 2 |
| Product No.2 | grade 3 |
| Product No.3 | grade 1 |
| Product No.3 | grade 2 |
| Product No.3 | grade 3 |
How can I do this?
I tried Join but it did not work.