主表
Name | W | H | D |
---|---|---|---|
Primary item 1 | 100 | 500 | 300 |
Primary item 2 | 100 | 600 | 300 |
Primary item 3 | 200 | 500 | 300 |
Primary item 4 | 100 | 500 | 300 |
Primary item 5 | 100 | 600 | 300 |
Primary item 6 | 200 | 500 | 300 |
辅助表
Name | W | H | D |
---|---|---|---|
Secondary item 1 | 100 | 500 | 300 |
Secondary item 2 | 100 | 600 | 300 |
Secondary item 3 | 200 | 500 | 300 |
Secondary item 4 | 100 | 500 | 300 |
Secondary item 5 | 100 | 600 | 300 |
Secondary item 6 | 200 | 500 | 300 |
结果
Name | W | H | D |
---|---|---|---|
Primary item 1 | 100 | 500 | 300 |
Secondary item 1 | 100 | 500 | 300 |
Secondary item 4 | 100 | 500 | 300 |
Primary item 4 | 100 | 500 | 300 |
Secondary item 1 | 100 | 500 | 300 |
Secondary item 4 | 100 | 500 | 300 |
W = 100 , H = 500 , D = 300 .
如何编写查询,以便第一个表的每一行都用第二个表的结果补充?
有可能这样做吗?
图片用于更好地理解#