problem with sql-statement

From: Henner Hucke <henner.hucke_at_rolls-royce.com>
Date: 7 May 2003 06:09:03 -0700
Message-ID: <f6796be6.0305070509.2882672f@posting.google.com>

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. Received on Wed May 07 2003 - 08:09:03 CDT