Difference between Oracle 8 and Oracle 9

Hello,

can anyone explain why a sql-statement runs correclty in an oracle8-database, but does something wrong in an oracle9-databse

This is the statement:
SELECT COUNT(*) AS D_INT_1 FROM TZV_LOG,TZV_GBUCH,TZV_DATA WHERE L_SEQ=D_SEQ

      AND L_LNR=D_LNR
      AND L_SEQ=G_REFSEQ
      AND L_LNR=G_REFLNR
      AND D_SEQ=G_REFSEQ
      AND D_LNR=G_REFLNR
      AND L_STAT='LFR' 
      AND D_STAT='DLE'
      AND L_ZV_EA='E'
      AND G_STAT='GFR'                             
      AND (G_ART='S' OR (G_ART='E' AND D_DNR=G_REFDNR))
      AND D_CPBUCH_FLAG IS NULL AND ROWNUM=1 ;

Under Oracle 8 the result is 1
Under Oracle 9 the result is 0

The both databases are totally equal and both users have the same rights.

Thank you everyone and please execuse my terrible english,

Sven Received on Thu Jan 16 2003 - 07:13:12 CST