String sql = "select top 3 UserInfo.userInfoId from News ,UserInfo where News.userInfoId = UserInfo.userInfoId " +
"and where in " +
"( select top 3 UserInfo.userInfoId from News ,UserInfo where News.userInfoId = UserInfo.userInfoId )"; stmt = DBHelper.getConnection().prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
System.out.print(rs.getString("UserInfoId") + " ");
}
"and where in " +
"( select top 3 UserInfo.userInfoId from News ,UserInfo where News.userInfoId = UserInfo.userInfoId )"; stmt = DBHelper.getConnection().prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
System.out.print(rs.getString("UserInfoId") + " ");
}
1.太复杂的sql语句Access不支持的。
2.where in 这个where是关键字,不能用做字段名。你可以加上''试试。