How to merge 2 resident tables ?

[#1]

Hi everyone,

In my model, there are 2 tables which are linked on a common field.  I would like to merge them so I have only one table and then export it into qvd.

I've tried this piece of code :

MergeTable:

LOAD *

resident Table1;

LEFT JOIN

LOAD *

resident Table2

;

But it doesn't work, I still have the 2 tables in my model.

What do I have to do ?

Thanks

[prieper]

The "MergeTable" is actually not necessary, it should be enough to JOIN and then drop the second table.

The first table will then contain the merged data.

HTH Peter