关于分页查询每个登录名对应不一样的表的问题
我做了一个分页查询,想每个登录名登陆的时候所看到的表不一样,我在goods表里建了外键userId,不过sql语句难倒我了..一个sql里没法写两个where..要怎样写呢?
String sql="SELECT TOP "+countPerPage+" * FROM d_goods WHERE id NOT IN(SELECT TOP "+index+" id FROM d_goods ORDER BY id)where userId=?ORDER BY id";