我现在要做这样一个查询 2张表：A,B，A表有字段id,name,B表有id,cid,content,uptime,其中A.id=B.cid， 现要查询A表的name对应B表的前3个connect，按照B表的uptime倒序排列 Select * from a t1 Inner join b t2 on t1.id=t2.cid and t2.content in (select top 3 b.content from b where b.cid=t1.id order by uptime desc)
但是提示This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' 但我用的也是mysql5.0的
网上查了下原因，也说是in里面不能有limit SQL code: Select * from a t1 Inner join b t2 on t1.id=t2.cid order by t2.uptime desc limit 3
先上错误 无法联接数据库 java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
