看看这个语句哪错了？（急）

boy0704

免费乐捐，感谢支持

strSql = "select * from (" +strSql+ ") as A where A.FSSJ >= '"+strfssjQ+"'";

运行后出现debug Database:

select * from (select S.FSSJ,S.YWDM,S.CONTENT,F.CLBZ,F.WGFSSJ,S.ID,F.MSJH,D.NSRSBH,Q.MC,S.CZYBM from WG_PLFSSJTEMP_CLONE S,WG_PLFSSJFJTEMP_CLONE F,XT_SJQYDY D,YW_QYXX Q where S.ID = F.SJ_ID and F.MSJH = D.SJH and D.NSRSBH=Q.NSRSBH  and (S.CZYBM in (select CZYDM from YW_CZYXX where  SWJGDM = '') or S.CZYBM like '%自动发送程序%')) as A where A.FSSJ >= '2005-04-24 13:31:15' and A.FSSJ <= '2007-04-25 13:31:15' order by A.ID

运行不过去~~错误：as附近有错。

哪个高手给看看哈~~

boy0704

 strSql=sql_top+" from WG_PLFSSJTEMP_CLONE S,WG_PLFSSJFJTEMP_CLONE F,XT_SJQYDY D,YW_QYXX Q";
      }else{
        strSql=sql_top+" from WG_PLFSSJTEMP S,WG_PLFSSJFJTEMP F,XT_SJQYDY D,YW_QYXX Q";
      }

      strSql=strSql + " where S.ID = F.SJ_ID and F.MSJH = D.SJH and D.NSRSBH=Q.NSRSBH "
          +" and (S.CZYBM in (select CZYDM from YW_CZYXX where  SWJGDM = '"
          + strSwjgdm + "') or S.CZYBM like '%自动发送程序%')";

      if (!(strfssjQ == null) && !strfssjQ.equals("")) {
          strSql = "select * from (" +strSql+ ") as A where A.FSSJ >= '"+strfssjQ+"'";
        }

      if (!(strfssjZ == null) && !strfssjZ.equals("")) {
          strSql = strSql+" and A.FSSJ <= '" + strfssjZ + "'";
      }

      if (!(strNSRSBH == null) && !strNSRSBH.equals("")) {
          strSql = strSql+" and A.NSRSBH like '%" + strNSRSBH + "%'";
      }

      if (!(strNSRMC == null) && !strNSRMC.equals("")) {
          strSql = strSql+" and A.MC like '%" + strNSRMC + "%'";
      }

      if (!(strSJH == null) && !strSJH.equals("")) {
          strSql = strSql+" and A.MSJH like'%" + strSJH + "%'";
      }

      if (!(strNR == null) && !strNR.equals("")) {
          strSql = strSql + " and A.CONTENT like '%" + strNR + "%'";
      }

      if (!(strYWDM == null) && !strYWDM.equals("")) {
        strSql = strSql + " and A.YWDM='" + strYWDM + "'";
      }

      if (!(strClbz == null) && !strClbz.equals("")) {
          strSql = strSql + " and A.CLBZ='" + strClbz + "'";
      }

      if (!(strFsr == null) && !strFsr.equals("")) {
          String strFsrdm=getFsrxx(null,strFsr);
          if(!(strFsrdm == null) && !"".equals(strFsrdm)){
              strSql=strSql + " and A.CZYBM = '"+strFsrdm+"' ";
          }
      }else{
        if(!"1".equals(strQx)){
          String strFsrdm=getFsrxx(null,strFsr);
          if(!(strFsrdm == null) && !"".equals(strFsrdm)){
            strSql=strSql + " and A.CZYBM = '"+strFsrdm+"' ";
          }
        }
      }

            strSql = strSql + " order by A.ID";

哪位大虾给看看啊！！

ehxz

AS A

做什么？

kingofse

&nbsp;&nbsp;&nbsp; 需要说明一下

boy0704

就是先通过查找，把符合条件的找出来后，以虚拟表的形式被另一个语句调用。我同事实现了该方法，不过他去出差了......我还是等他来了帮我吧。呵呵~~