mysql> select a.*,b.col4 from a,b where a.col2>=b.col2 and a.col2<=b.col3;
+------+------+------+
| col1 | col2 | col4 |
+------+------+------+
| 1 | 30 | 25 |
| 2 | 40 | 65 |
| 3 | 80 | 90 |
+------+------+------+
3 rows in set (0.03 sec)
+------+------+------+
| col1 | col2 | col4 |
+------+------+------+
| 1 | 30 | 25 |
| 2 | 40 | 65 |
| 3 | 80 | 90 |
+------+------+------+
3 rows in set (0.03 sec)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货