Whoa, that sure doesn't seem right to me.
YOu might want to try 7.3.0.29 and see what happens - SAP did a major rework
of the join logic to support ANSI compliance ("LEFT OUTER" syntax). I
expect they might have fixed a few things :)
Looking at your sample, it might explain why I had so much trouble with this
when I was doing some coding 3 months ago.
Stephen
-----Original Message-----
From: Stefan Gustafsson [mailto:sg@;steria.se]
Sent: Thursday, November 07, 2002 12:39 AM
To: [EMAIL PROTECTED]
Subject: Join problem
Hello,
Can someone please explain why these joins give different results.
// First select, work as expected
SELECT A.o,A.a,B.b,C.c FROM A,B,C WHERE A.o = B.o (+) AND A.o = C.o (+)
// Second select. Gives two rows where b and c is NULL!
SELECT A.o,A.a,B.b,C.c FROM C,B,A WHERE A.o = B.o (+) AND A.o = C.o (+)
Is this a bug or do I need to order by tables in the FROM statement
depending on how i do my join?
I use:
Kernel 7.3.0 Build 025-000-085-923
NT/INTEL 7.3.0 Build 025-000-085-923
Best Regards,
Stefan Gustafsson
CTO IT-Security
Steria AB
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
