一个SQL语句的转换问题,求教(sybase>oracle)

lbx1979 2003-03-11 11:43:41

SELECT TBSJDZ_DZBH ,
KMJE_KJND,
KMJE_KJQJ,
KMJE_NCYE,
0.0 AS KMJE_JFLJ,
0.0 AS KMJE_DFLJ,
0.0 AS KMJE_JFFS,
0.0 AS KMJE_DFFS,
KMJE_NCYE
FROM KMJE,TBSJDZ
WHERE (KMJE_KJND='2003' AND KMJE_KJQJ='03') AND
TBSJDZ_DZBH IN (SELECT KMZD_KMBH FROM KMZD WHERE KMZD_MX=1) AND
(TBSJDZ_SJLX='KM' AND TBSJDZ_SYBH = KMJE_KMBH)
这个sql在sybase里是正常的,到oracle里就不行了:(

200分求教!

...全文

166 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

bzszp 2003-03-11

打赏
举报

去掉as

Lastdrop 2003-03-11

打赏
举报

报什么错？

lbx1979 2003-03-11

打赏
举报

zhenyukeji(何处是我家)你写的和我写的有什么区别??

mywhsw 2003-03-11

打赏
举报

最好把别名写上，比如select a.aaa as a1, b.aaa as a2 from table1 a,table2,b where a.a4=b.a4........

岁月无声-我心飞翔 2003-03-11

打赏
举报

SELECT TBSJDZ_DZBH ,
KMJE_KJND,
KMJE_KJQJ,
KMJE_NCYE,
'0.0' KMJE_JFLJ,
'0.0' KMJE_DFLJ,
'0.0' KMJE_JFFS,
'0.0' KMJE_DFFS,
KMJE_NCYE
FROM KMJE,TBSJDZ
WHERE (KMJE_KJND='2003' AND KMJE_KJQJ='03') AND
TBSJDZ_DZBH IN (SELECT KMZD_KMBH FROM KMZD WHERE KMZD_MX=1) AND
(TBSJDZ_SJLX='KM' AND TBSJDZ_SYBH = KMJE_KMBH)

岁月无声-我心飞翔 2003-03-11

打赏
举报

SELECT TBSJDZ_DZBH ,
KMJE_KJND,
KMJE_KJQJ,
KMJE_NCYE,
'0.0' AS KMJE_JFLJ,
'0.0' AS KMJE_DFLJ,
'0.0' AS KMJE_JFFS,
'0.0' AS KMJE_DFFS,
KMJE_NCYE
FROM KMJE,TBSJDZ
WHERE (KMJE_KJND='2003' AND KMJE_KJQJ='03') AND
TBSJDZ_DZBH IN (SELECT KMZD_KMBH FROM KMZD WHERE KMZD_MX=1) AND
(TBSJDZ_SJLX='KM' AND TBSJDZ_SYBH = KMJE_KMBH)

beckhambobo 2003-03-11