LIMIT＆INALLANYSOME子查询出现问题

LIMIT＆IN / ALL / ANY / SOME子查询出现问题

这就是您需要进行的 *** 作。请参阅我已经解决的示例。

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)

希望这可以帮助。