此图显示在 Order ID 列上联接的 Orders 表和 Order Items 表。
| Order ID | Order Total |
|---|---|
| 1001 | 50.97 |
| 1002 | 1249.91 |
| Order ID | Product ID | Quantity |
|---|---|---|
| 1001 | 40 | 1 |
| 1001 | 63 | 2 |
| 1002 | 29 | 1 |
| 1002 | 14 | 3 |
| 1002 | 2 | 1 |
| Order ID | Product ID | Order Total | Quantity |
|---|---|---|---|
| 1001 | 40 | 50.97 | 1 |
| 1001 | 63 | 50.97 | 2 |
| 1002 | 29 | 1249.91 | 1 |
| 1002 | 14 | 1249.91 | 3 |
| 1002 | 2 | 1249.91 | 1 |