Abaco Inform�tica S.A. wrote: > look at this scripts: > > CREATE TABLE T1 (COD_1 FIXED(4), VAL_1 FIXED(4)) > CREATE TABLE T2 (COD_2 FIXED(4), VAL_2 FIXED(4)) > CREATE TABLE T3 (COD_3 FIXED(4), VAL_3 FIXED(4)) > INSERT INTO T1 VALUES (1,1) > INSERT INTO T1 VALUES (2,2) > INSERT INTO T1 VALUES (3,3) > > INSERT INTO T2 VALUES (1,1) > INSERT INTO T2 VALUES (2,2) > > nothing for T3. > > SELECT * FROM T1 LEFT JOIN T2 ON (VAL_1 = COD_2) > > result 3 rows (third row null in val_2,cod_2, it's work fine) > > SELECT * FROM T1 LEFT JOIN T2 ON (VAL_1 = COD_2) LEFT JOIN T3 ON (VAL_2 = COD_3) > > result 2 rows !!??? > > > i think find 3 row with nulls in the columns of 3rd. table but the row with nulls in > T2 disappear, what i doing wrong.
This is a known bug and already fixed within release >= 7.3.0.36 and >= 7.4.3.24 Thanks for reporting. Best regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
