esclarecimento+operador !=

olá a todos tenho esta instrução:

select Z_EVENT.EVENTTIMESTAMP , Z_EVENT.DOWNTIMESTAMP ,Z_EVENT.DOWNTIME, Z_EVENT.ORDERNUMBER

from Z_EVENT

where Z_EVENT.PLANT ='CLPP' and

 Z_EVENT.LINENUMBER = '32027' and

 Z_EVENT.EVENTTIMESTAMP >= to_date('20.08.2009 00:00:00', 'dd.mm.YYYY hh24:mi:ss') and

 Z_EVENT.EVENTTIMESTAMP <= to_date('28.08.2009 23:59:59', 'dd.mm.YYYY hh24:mi:ss') and

 Z_EVENT.REASONCODE != '000'

 and Z_EVENT.MACHINE='M1'

order by Z_EVENT.EVENTTIMESTAMP asc

mas agora tenho outro reasoncode que tb não pode ser apanhado...(desculpem a minha explicação..estranha)

fica assim:

select Z_EVENT.EVENTTIMESTAMP , Z_EVENT.DOWNTIMESTAMP ,Z_EVENT.DOWNTIME, Z_EVENT.ORDERNUMBER

from Z_EVENT

where Z_EVENT.PLANT ='CLPP' and

 Z_EVENT.LINENUMBER = '32027' and

 Z_EVENT.EVENTTIMESTAMP >= to_date('20.08.2009 00:00:00', 'dd.mm.YYYY hh24:mi:ss') and

 Z_EVENT.EVENTTIMESTAMP <= to_date('28.08.2009 23:59:59', 'dd.mm.YYYY hh24:mi:ss') and

 Z_EVENT.REASONCODE != '000' and Z_EVENT.REASONCODE != '101'

 and Z_EVENT.MACHINE='M1'

order by Z_EVENT.EVENTTIMESTAMP asc

ou tb funciona desta maneira:

select Z_EVENT.EVENTTIMESTAMP , Z_EVENT.DOWNTIMESTAMP ,Z_EVENT.DOWNTIME, Z_EVENT.ORDERNUMBER

from Z_EVENT

where Z_EVENT.PLANT ='CLPP' and

 Z_EVENT.LINENUMBER = '32027' and

 Z_EVENT.EVENTTIMESTAMP >= to_date('20.08.2009 00:00:00', 'dd.mm.YYYY hh24:mi:ss') and

 Z_EVENT.EVENTTIMESTAMP <= to_date('28.08.2009 23:59:59', 'dd.mm.YYYY hh24:mi:ss') and

 Z_EVENT.REASONCODE NOT IN ('000','101')

 and Z_EVENT.MACHINE='M1'

order by Z_EVENT.EVENTTIMESTAMP asc

abraço e obrigado

matinha