Question

[ODBC Microsoft Access 驱动程序] 语法错误。 在查询表达式 'id not in(select top 0 * id from tb_acti

String sql="select top 20 * from tb_event where id not in(select top "+down.getPageSize()*page+" id from tb_event order by id)order by id";

执行后出现错误
select top 10 * from tb_activity where id not in(select top 0 * id from tb_activity order by id)order by id
java.sql.SQLException: [Microsoft][ODBC Microsoft Access 驱动程序] 语法错误。 在查询表达式 'id not in(select top 0 * id from tb_activity order by id)' 中。

Answer 1

你这个语句写的没什么意义 条件直接写id<>0 不好吗？