Re: problem with sql-statement

From: David Fitzjarrell <oratune_at_msn.com>
Date: 7 May 2003 10:40:32 -0700
Message-ID: <32d39fb1.0305070940.66ce7007@posting.google.com>

henner.hucke_at_rolls-royce.com (Henner Hucke) wrote in message news:<f6796be6.0305070509.2882672f_at_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.

Look at both queries again, CLOSELY. Apparently no records in your table match the following criteria: UPPER(MBD_WORKFLOWEBENE) = 'AUSSTELLER'. Also note that condition is MISSING from your latter query. I think you've now found the cause of your dilemma.

David Fitzjarrell Received on Wed May 07 2003 - 12:40:32 CDT