SQL语句
帮我看看：我的查询
select A.rq, A.gz,A.zje
from
(select decode(sign(to_char(rqsj,'dd')-25),1,trunc(add_months(rqsj,1),'mm'),trunc(rqsj,'mm')) as rq,
substr( "FUTUREPOS"."XS"."gz",1,2) as gz,
"FUTUREPOS"."XS"."XSE" as zje
from "FUTUREPOS"."XS") as A
where ( - A.zje) not in
( select "XSE" from "FUTUREPOS"."XS" where xse>0)
先谢谢了
问题点数：20、回复次数：3Top
1 楼goldocean（）回复于 2003-09-02 19:27:07 得分 0
rq(日期),gz(商场),zje(金额)
错误提示：sql命令未正确结束Top
2 楼goldocean（）回复于 2003-09-02 19:29:50 得分 0
rq(日期),gz(商场),zje(金额)
错误提示：SQL命令未正确结束Top
3 楼BlueskyWide（谈趣者）回复于 2003-09-02 19:35:52 得分 20
在FUTUREPOS用户下：
select decode(sign(to_char(rqsj,'dd')-25),1,trunc(add_months(rqsj,1),'mm'),trunc(rqsj,'mm')) rq,substr(gz,1,2) gz,xse from xs where xse<=0;Top
4 楼goldocean（）回复于 2003-09-02 19:46:29 得分 0
To:： BlueskyWide(谈趣者)
你的这句话？？Top
