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)
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)
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)
不是 as的问题,as在oracle也能用
是这个语句不能返回记录,而在sybase里就可以
没有高手吗?