Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Yeah, thanks!
Cuold you please give me a mark is the answer has been useful?
Thanks
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