By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
product_id | title | category_id | title | product_id | category_id |
---|---|---|---|---|---|
1 | product1 | 1 | category1 | 1 | 1 |
1 | product1 | 2 | category2 | 1 | 2 |
1 | product1 | 3 | category3 | 1 | 3 |
2 | product2 | 3 | category3 | 2 | 3 |
2 | product2 | 4 | category4 | 2 | 4 |
3 | product3 | 1 | category1 | 3 | 1 |
product_id | title | category_id | title | product_id | category_id |
---|---|---|---|---|---|
4 | product4 | 1 | category1 | null | null |
3 | product3 | 1 | category1 | 3 | 1 |
2 | product2 | 1 | category1 | null | null |
1 | product1 | 1 | category1 | 1 | 1 |
4 | product4 | 2 | category2 | null | null |
3 | product3 | 2 | category2 | null | null |
2 | product2 | 2 | category2 | null | null |
1 | product1 | 2 | category2 | 1 | 2 |
4 | product4 | 3 | category3 | null | null |
3 | product3 | 3 | category3 | null | null |
2 | product2 | 3 | category3 | 2 | 3 |
1 | product1 | 3 | category3 | 1 | 3 |
4 | product4 | 4 | category4 | null | null |
3 | product3 | 4 | category4 | null | null |
2 | product2 | 4 | category4 | 2 | 4 |
1 | product1 | 4 | category4 | null | null |
4 | product4 | 5 | category5 | null | null |
3 | product3 | 5 | category5 | null | null |
2 | product2 | 5 | category5 | null | null |
1 | product1 | 5 | category5 | null | null |