> Sven Köhler wrote: > > > here a small statement > > > > SELECT a.id > > FROM a > > LEFT JOIN b ON (b.id2=a.id2) > > LEFT JOIN c ON (c.id2=a.id2) > > > > this statement works as expected and returns all rows of table a. > > > > SELECT a.id > > FROM a > > LEFT JOIN b ON (b.id2=a.id2) > > LEFT JOIN c ON (c.id2=b.id2) > > > > (i only changed a.id2 into b.id2 for the second left join) > > this statement doesn't work as expected. only some rows of > > table a are > > returned, all where rows a.id2 is not null. > > the result should contain _every_ row of table a for _any_ > > join-condition because i only to left joins. > > Oops, it's a bug. > We will fix it in one of the next patches. > Thank you for reporting it.
In version 7.4.3.17 this bug is still. And in Oracle style select mode (with (+) ). > > Kind regards, > Holger > SAP Labs Berlin > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > Pavel Konovalov ________________________________ JS RCOM, Russia http://www.rscom.ru _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
