Abaco Inform�tica S.A. wrote: > Try This: > > 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. > > then: > > select * from t1 left join t2 on (val_1 = cod_2) left join t3 on ( val_2 = cod_3) > > 3 rows (it's ok) > > select * from t1 left join t2 on (val_1 = cod_2) left join t3 on (cod_3 = val_2) > > 0 rows !! (It is wrong) > > Watch the last 'ON' condition. > > Well, that is my problem now, can somebody suggest something to fix this? or I must > be carefully with the order of operands?
This is a unknown bug. It's an error in the algorithm to assign the columns to the right table in the on clause. We will fix it with one of the next releases. Thank you for reporting and sorry for any inconvenience. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
