Re: problem with sql-statement

henner.hucke_at_rolls-royce.com said...
> Hello,
>
> I have a problem with the following SQL-Statement:
> (Oracle 8.1.7.4 on Solaris 2.6)
>
> If I run
> select mbd_number from M10000 where
> (
> UPPER(MBD_WORKFLOWEBENE) = 'AUSSTELLER'
> AND
> MBD_AUSSTELLER_STNR = '000000'
> )
> OR
> (
> UPPER(MBD_FEHLERGRUPPE) = 'AUSSTELLER'
> AND
> MBD_AUSSTELLER_STNR = '000000'
> AND
> UPPER(MBD_WORKFLOWEBENE) = 'AUSSTELLER'
> )
> I get 'no rows selected'
>
> If I run
>
> select mbd_number from M10000 where
> (
> UPPER(MBD_WORKFLOWEBENE) = 'AUSSTELLER'
> AND
> MBD_AUSSTELLER_STNR = '000000'
> )
>
> I get one row presented.
>
> I have no idea where my error is.
> Please can someone help me?
> Thanks.
>

Do any of the columns (especially MBD_FEHLERGRUPPE) contain a null?

-- 
/Karsten
DBA > retired > DBA