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.
i'm using SAPDB 7.4.3.14
you can reproduce it with these tables:
create table a(id int, id2 int) // create table b(id2 int) // create table c(id2 int) // insert into a(id, id2) values (1,2)
table b and c stay empty.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
