这就是您需要进行的操作。请参阅我已经解决的示例。
mysql> select * from test;+------+-------+| id | name |+------+-------+| 1 | name1 || 2 | name2 || 3 | name3 || 4 | name4 |+------+-------+4 rows in set (0.00 sec)mysql> select * from test1;+------+------+--------+| id | tid | name2 |+------+------+--------+| 1 | 2 | name11 || 2 | 3 | name12 || 3 | 4 | name13 |+------+------+--------+3 rows in set (0.00 sec)mysql> select -> t1.name -> from -> test t1 -> join -> test1 t2 on t2.tid = t1.id -> join -> (select id from test where id <4 limit 3) as tempt on tempt.id = t1.id;+-------+| name |+-------+| name2 || name3 |+-------+2 rows in set (0.00 sec)
希望这可以帮助。
