在使用Sybase时，建了一个视图
QUOTE:
CREATE VIEW VIEW_KPI_DW_CITY_DYBHG
AS
SELECT T.COMPLETE_NAME,
(100-V.D_CHECK)/100*datediff( DAY,DATEADD(MONTH,-1,S.QSSJ) , S.QSSJ ) AS BHGSJ,
(100-V1.D_CHECK)/100*datediff( DAY,DATEADD(MONTH,-1,S.QSSJ) , S.QSSJ ) AS L_BHGSJ,
V.NIANDU,V.YUEFEN,S.MONTH_KEY
FROM EPMS_UNIT T, EPMS_VOLT V,
EPMS_VOLT V1,VIEW_EPMS_GD_ZY_CITY S
WHERE v.UNIT_CODE=v1.UNIT_CODE
and T.UNIT_CODE=V.UNIT_CODE
AND S.DWMC=T.COMPLETE_NAME
AND V.NIANDU=S.YEAR
AND V.YUEFEN=S.MONTH
and v.yuefen=v1.yuefen
and v.niandu=(v1.niandu+1)
通过查询语句
select * from VIEW_KPI_DW_CITY_DYBHG
其结果没有问题
但 select * from VIEW_KPI_DW_CITY_DYBHG where NIANDU=2007
时出现如下异常：
QUOTE:
Input to merge join #03 from child #04 not ordered as required ,
key :V1.unit_code
请问要怎么解决啊，同样的视图在Oracle下没啥问题。
