Problems With outer join, outer joined row icondition does not work if joined row is null, no way of testing for nulls in outer table !
drop table tempa;
drop table tempc;
create table tempA(PK Integer, FK INTEGER, FK2 Char(1));
create table tempC(PK Char(1));
INSERT INTO tempA VALUES (10, null, 'A');
INSERT INTO tempA VALUES (20, 10, 'B');
INSERT INTO tempA VALUES (30, 40, 'A');
INSERT INTO tempC VALUES ('A');
INSERT INTO tempC VALUES ('B');
select A=2EPK, A=2EFK, B=2EPK, B=2EFK2, C=2EPK=20
FROM tempA As A, OUTER (tempA As B, tempC As C)
Where A=2EFK=3DB=2EPK
AND B=2EFK2=3DC=2EPK
AND C=2Epk is not null
AND C=2Epk In('A')
It is showing rows where C=2Epk is null an is not in 'A'=2E Is it a bug ???=
? Please=20
help=20
__________________________________________________
This message is intended only for the use of the=20
Addressee and may contain information that is=20
PRIVILEGED and CONFIDENTIAL=2E If you are not the
intended recipient, you are hereby notified that
any dissemination of this communication is
strictly prohibited=2E If you have received this
communication in error, please erase all copies of
the message and its attachments and notify us
immediately=2E Thank You=2E
__________________________________________________