I now remeber why I used the (+) syntax, the FROM syntax does not work. I have tried to rewrite my example using the ANSI syntax but I can't get 7.3.00.25 to accept more than one join at the time.
SELECT A.o,A.a,B.b,C.c FROM A LEFT JOIN B USING (o) LEFT JOIN C USING (o) gives -3014 Syntax error or access violation;-3014 POS(53) Invalid end of SQL statement. Also SELECT A.o,A.a,B.b,C.c FROM A LEFT JOIN B USING (o), C gives two rows with all columns set. I was expecting a NULL in the second row. Can someone please test these on a 7.3.00.29 and report if it work in that version? Regards, Stefan Gustafsson > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:sapdb.general-admin@;listserv.sap.com]On Behalf Of Sven Kohler > Sent: den 7 november 2002 21:26 > To: [EMAIL PROTECTED] > Subject: Re: Join problem > > > > 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 :) > > > Already tested that. > The results are as wrong as in 7.3.0.25 > > > Looking at your sample, it might explain why I had so much trouble > > with this > > when I was doing some coding 3 months ago. > > This is a somewhat "strange" syntax. Is the (+) part of any SQL-Standard? > > After i knew what that (+) is for, i decided do ban that from my mind. > It is much more logical to declare an OUTER JOIN (that's what the (+) is > for) in the FROM clause. It doesn't make much sense to me to put it into > the WHERE clause. > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
