ds = sqlhelper.GetDataSet("select top " + limit + " * from xcfymx,fcqk where xcfymx.fhqdh=fcqk.fhqdh and fcqk.fhqdh not in(select top " + start + " fcqk.fhqdh from xcfymx,fcqk where xcfymx.fhqdh=fcqk.fhqdh ) ");ds = sqlhelper.GetDataSet("select xcfymx.fhqdh,fcqk.clbh,xcfymx.xhz,fcqk.fcsj,fcqk.fc_zdzmc,xcfymx.yjddsj,xcfymx.sjdzsj,xcfymx.lksj,xcfymx.ycqk,xcfymx.qrr from xcfymx,fcqk where xcfymx.fhqdh = fcqk.fhqdh and (fcqk.clbh like '% " + clbh + " %' and sdzmc like '% " + sdzmc + " %') and DateDiff(d,'" + fcsj1 + "',fcsj)>=0 And DateDiff(d,fcsj,'" + fcsj2 + "')>=0 ");这两条查询出来的都是5条记录啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货