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.
Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
