Hi
I am using SAP DB 7.3 (Kernel 7.3.0 Build 029-000-087-809)
I execute the following statements:
create table t1 (ch1 char(10))
create table t2 (ch2 char(10), i2 integer)
create table t3 (ch3 char(10), i3 integer)
create table t4 (ch4 char(10))
insert into t1 values ('error')
insert into t2 values ('error', 2)
insert into t3 values ('error3', 2)
select ch1
from t1
result is string:
error
This result is correct.
select ch2
from t2, t3
where i2 = i3 and ch3 = 'error3' and ch2 not in (select ch4 from t4)
result is string:
error
This result is correct.
Now execute
select *
from t1
where ch1 not in (select ch2
from t2, t3
where i2 = i3 and ch3 = 'error3' and ch2 not in
(select ch4 from t4))
For my surprise result is again string:
error
And is is realy an error :(
Milen Manev
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr f�r 1 ct/ Min. surfen!
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
