informix 数据库查询问题,

yuan066 2006-01-18 09:55:56

本人才接触informix数据库不久,,老板要我开发一个项目,数据库informix, 下面是查询语句:

select iptbop.numeroordemproduca,count(*) as count_output,
(select count(*) as aaa from ipitunico,iptbop where ipitunico.numeroordemproduca=iptbop.numeroordemproduca and iptbop.dataemissao='2005/12/26' AND ipitunico.dtplanejamento='2005/12/26' AND ipitunico.numfisicoposto='47' GROUP BY iptbop.numeroordemproduca) as bbb
from ipitunico,iptbop,ipplanlinmod,iptbpost where ipitunico.numeroordemproduca=iptbop.numeroordemproduca AND iptbop.dataemissao='12/26/2005' AND
ipitunico.dtplanejamento='12/26/2005' and ipplanlinmod.numeroordemproduca=iptbop.numeroordemproduca and iptbpost.tipoposto='a' and iptbpost.cdfaseproducao=ipplanlinmod.cdfaseproducao and iptbpost.cdlinha=ipplanlinmod.cdlinha
and ipitunico.numfisicoposto=iptbpost.numfisicoposto GROUP BY iptbop.numeroordemproduca

不知道为什么一直报错,, 请各位高手帮忙看看,, 谢谢各位了.

...全文

332 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

超叔csdn 2006-04-21

打赏
举报

SELECT语句作为字段是可以的.我现在在做一个项目,把DB2的语句改成INFORMIX.学了点皮毛,但是SELECT语句作为字段是可以的.

超叔csdn 2006-04-21

打赏
举报

select iptbop.numeroordemproduca,count(*) as count_output,
(select count(*) as aaa from ipitunico,iptbop where ipitunico.numeroordemproduca=iptbop.numeroordemproduca and iptbop.dataemissao='2005/12/26' AND ipitunico.dtplanejamento='2005/12/26' AND ipitunico.numfisicoposto='47' GROUP BY iptbop.numeroordemproduca) as bbb
from ipitunico,iptbop,ipplanlinmod,iptbpost where ipitunico.numeroordemproduca=iptbop.numeroordemproduca AND iptbop.dataemissao='12/26/2005' AND
ipitunico.dtplanejamento='12/26/2005' and ipplanlinmod.numeroordemproduca=iptbop.numeroordemproduca and iptbpost.tipoposto='a' and iptbpost.cdfaseproducao=ipplanlinmod.cdfaseproducao and iptbpost.cdlinha=ipplanlinmod.cdlinha
and ipitunico.numfisicoposto=iptbpost.numfisicoposto GROUP BY 1,3

超叔csdn 2006-04-19

打赏
举报

bombplane(luzhen) :
好象可以啊，可以为SELECT语句啊。
这里应该是GROUP BY 的问题吧。因为这里的SELECT 作为字段，而你的分组没有这个东西，看你的逻辑到底是怎样的？

river_good 2006-04-12

打赏
举报

借贵地沾下光
rivergood@163.com
还请大侠也发份给我，不盛感谢

bombplane 2006-03-16

打赏
举报

INFORMIX的SELECT语法中字段名不能是子SELECT语句。如果你有兴趣我可以把INFORMIX SQL GUILDE（英文版）、IDS Administration Guide（英文版）和Informix Backup and Restore Guide（英文版）发给你，请留下你的EMAIL地址。其他有兴趣的人也可以联系我，EMAIL：bombplane@21cn.com。