我有2张桌子：
表格1：
+-----+-----+-------+
| ID | num | title |
+-----+-----+-------+
| 101 | 0 | pro |
+-----+-----+-------+
| 102 | 0 | xtr |
+-----+-----+-------+
| 103 | 0 | low |
+-----+-----+-------+
| 104 | 0 | hi |
+-----+-----+-------+
和表2：
+-----+--------+
| Nn | title |
+-----+--------+
| 1 | ttl1 |
+-----+--------+
| 2 | ttl2 |
+-----+--------+
| 3 | ttl3 |
+-----+--------+
我需要mysql请求来填充表3，例如：
+-----+-----+
| ID | Nn |
+-----+-----+
| 101 | 1 |
+-----+-----+
| 101 | 2 |
+-----+-----+
| 101 | 3 |
+-----+-----+
| 102 | 1 |
+-----+-----+
| 102 | 2 |
+-----+-----+
| 102 | 3 |
+-----+-----+
| 103 | 1 |
+-----+-----+
| 103 | 2 |
+-----+-----+
| 103 | 3 |
...
即每一个ID从table1我需要所有Nn的table2。
我写了下面的sql请求，效果很好，但是我需要sql请求才能使用JOIN语句，该怎么办？
INSERT INTO `table3` ( `ID`, `Nn` )
SELECT `t1`.`ID`, `t2`.`Nn`
FROM `table1` as `t1`, `table2` as `t2`;
使用交叉联接：
INSERT INTO `table3` ( `ID`, `Nn` )
SELECT `t1`.`ID`, `t2`.`Nn`
FROM `table1` as `t1` CROSS JOIN `table2` as `t2`;
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句