Esta bien hecho este JOIN?

[#1]

Tengo una tabla ya cargada

TablAA:

CampoA

CampoB

CampoC

Luego una tabla "temporal", con los campos

Temp:

Campo A

Campo D

Campo E

Y ahora quiero agregarle, a la TABLAA, los campos D y E, macheando por el CAMPO A

Left join (TablaA)

LOAD Campo A, Campo D, Campo E

Resident Temp;

Es correcto?

Saludos y gracias

[alexandros17]

Is correct but field names must be the same CampoA and CampoA (not Campo A) see the space ...

After the join remember to drop table Temp

[#3]

Yeah, thanks!

[alexandros17]

Cuold you please give me a mark is the answer has been useful?

Thanks

[#5]

Done

What if i want to create a MasterKey but changing some ids in order to not duplicate fields. Is it ok? (not related with the previous example)

Autonumber(FieldA*10000&'-'&FieldB) in one Table

Autonumber(FieldC*20000&'-'&FieldB) in the other Table