语法错误 (操作符丢失) 在查询表达式 'id not in(select top 8 id from pro3 where pro2_id=27 order by addtime desc) where pro2_id=27' 中。SQL语句是: strSql = "select top 8 * from pro3 where id not in(select top " + p + " id from pro3 where pro1_id=" + pro1_id + " order by addtime desc) where pro1_id=" + pro1_id + " order by addtime desc";
而不是
where id not in() where pro1_id=..
SQL语句是: strSql = "select top 8 * from pro3 where id not in(select top " + p + " id from pro3 where pro1_id=" + pro1_id + " order by addtime desc) where pro1_id=" + pro1_id + " order by addtime desc";
select top 8 * from pro3
where id not IN
(
select top 1 id from pro3 where pro1_id=2 order by addtime DESC
)
and pro1_id=2
order by addtime desc