data load editor: select & load

[wanyunyang]

Hi guys,

I come across I problem I don't understand:

In my data load editor, I have table1 with fields A, B, table2 with fields A, C. My script is:

TABLE:

SELECT A, B FROM table1;

LEFT JOIN (TABLE)

SELECT A, C FROM table2;

LOAD A,B,C RESIDENT TABLE;

But everything is duplicated. If I remove the LOAD, everything is correct. I don't quite understand why. Any idea? Is there any reference regarding this?

Thanks for help!

[sasiparupudi1]

TABLE:

SQL SELECT A, B FROM table1;

LEFT JOIN (TABLE)

SQL SELECT A, C FROM table2;

final:

noconcatenate LOAD A,B,C RESIDENT TABLE;

drop table TABLE;