SELECT SUM(KCRKD2_SSSL) FROM HMHTGY,KCRKD2,BFGBD,BFGBGL
WHERE BFGBD_LSBH = KCRKD2_GBDLS AND HMHTGY_LSBH = BFGBGL_LYLS AND BFGBGL_LSBH=BFGBD_LSBH
WHERE F_HTBH IN (SELECT HMHTGY_HTBH FROM HMHTGY,KCRKD2,BFGBD,BFGBGL
WHERE BFGBD_LSBH = KCRKD2_GBDLS AND HMHTGY_LSBH = BFGBGL_LYLS AND BFGBGL_LSBH = BFGBD_LSBH)
这句在SQLSERVER上可以执行 在ORACLE中老提示“命令未正确结束”显示“WHERE F_HTBH IN (SELECT HMHTGY_HTBH FROM HMHTGY,KCRKD2,BFGBD,BFGBGL ”的WHERE下有个小红波浪线------------------------------------------------------------------------------------------------------
另:大家新年快乐~~~
WHERE BFGBD_LSBH = KCRKD2_GBDLS AND HMHTGY_LSBH = BFGBGL_LYLS AND BFGBGL_LSBH=BFGBD_LSBH
WHERE F_HTBH IN (SELECT HMHTGY_HTBH FROM HMHTGY,KCRKD2,BFGBD,BFGBGL
WHERE BFGBD_LSBH = KCRKD2_GBDLS AND HMHTGY_LSBH = BFGBGL_LYLS AND BFGBGL_LSBH = BFGBD_LSBH)
这句在SQLSERVER上可以执行 在ORACLE中老提示“命令未正确结束”显示“WHERE F_HTBH IN (SELECT HMHTGY_HTBH FROM HMHTGY,KCRKD2,BFGBD,BFGBGL ”的WHERE下有个小红波浪线------------------------------------------------------------------------------------------------------
另:大家新年快乐~~~
解决方案 »
- 如何累计表中某字段的局部数据,是局部数据,不是整个字段?????(帮转)
- 32位oracle装在64位操作系统出现的问题
- 这条 SQL 语句如何简化
- 安装ORACLE9i于中文Windows XP
- 急求BIBeans开发Oracle数据仓库项目资料!!!
- 多线程的pro*c 编译问题
- 写了一点游标的,执行后,好多错啊,帮我改改!!
- 两个sql语句一样只有条件不一样,如何取并集?
- 哪里有《oracle8 完全参考手册》(机械工业出版社)的电子版下载 要多少分都成啊
- 一个简单的问题,如何定义一个全局变量?
- System.Data.OracleClient 需要 Oracle 客户端软件 8.1.7 或更高版本
- varchar2
UPDATE T_CGHTGZCX125 SET F_RKDDHSL = (SELECT SUM(KCRKD2_SSSL) FROM HMHTGY,KCRKD2,BFGBD,BFGBGL WHERE BFGBD_LSBH = KCRKD2_GBDLS AND HMHTGY_LSBH = BFGBGL_LYLS AND BFGBGL_LSBH=BFGBD_LSBH) WHERE F_HTBH IN (SELECT HMHTGY_HTBH FROM HMHTGY,KCRKD2,BFGBD,BFGBGL WHERE BFGBD_LSBH = KCRKD2_GBDLS AND HMHTGY_LSBH = BFGBGL_LYLS AND BFGBGL_LSBH = BFGBD_LSBH)
SET F_RKDDHSL = (SELECT SUM(KCRKD2_SSSL)
FROM HMHTGY, KCRKD2, BFGBD, BFGBGL
WHERE BFGBD_LSBH = KCRKD2_GBDLS
AND HMHTGY_LSBH = BFGBGL_LYLS
AND BFGBGL_LSBH = BFGBD_LSBH)
WHERE F_HTBH IN (SELECT HMHTGY_HTBH
FROM HMHTGY, KCRKD2, BFGBD, BFGBGL
WHERE BFGBD_LSBH = KCRKD2_GBDLS
AND HMHTGY_LSBH = BFGBGL_LYLS
AND BFGBGL_LSBH = BFGBD_LSBH)这个语句没问题吧。SELECT SUM(KCRKD2_SSSL)
FROM HMHTGY, KCRKD2, BFGBD, BFGBGL
WHERE BFGBD_LSBH = KCRKD2_GBDLS
AND HMHTGY_LSBH = BFGBGL_LYLS
AND BFGBGL_LSBH = BFGBD_LSBH
WHERE F_HTBH IN (SELECT HMHTGY_HTBH
FROM HMHTGY, KCRKD2, BFGBD, BFGBGL
WHERE BFGBD_LSBH = KCRKD2_GBDLS
AND HMHTGY_LSBH = BFGBGL_LYLS
AND BFGBGL_LSBH = BFGBD_LSBH)
这个语句就有问题
FROM HMHTGY,KCRKD2,BFGBD,BFGBGL
WHERE BFGBD_LSBH = KCRKD2_GBDLS AND HMHTGY_LSBH = BFGBGL_LYLS AND BFGBGL_LSBH=BFGBD_LSBH and a.F_HTBH=HMHTGY_HTBH)
WHERE F_HTBH IN
(SELECT HMHTGY_HTBH FROM HMHTGY,KCRKD2,BFGBD,BFGBGL
WHERE BFGBD_LSBH = KCRKD2_GBDLS AND HMHTGY_LSBH = BFGBGL_LYLS AND BFGBGL_LSBH = BFGBD_LSBH)
这句下有红线 说明这句错了! 你上边已经有一个where了 这里又一个where当然会出错 改成 and
貌似没啥问题啊