How to inner join this two tables by one key and conserving their labels

[ChristianMaury]

I have this two tables

And I want to inner join them but conserving their labels except the key field

Can help me please?

[rubenmarin]

Hi, what are labels?, you want to keep both tables? To do this you can try with inner keep

[micheledenardi]

OrdersCopiaEditada:
Load 
Key1,
OrdersCopiaEditada.OrderID as OrderID,
OrdersCopiaEditada.CusomerID as OrderID,
...
...
From ....;

Inner Join(OrdersCopiaEditada)
load
Key1,
OrderCopiaExacta.OrderID as ExOrderID,
OrderCopiaExacta.CustomerID as ExCustomerID,
...
...
From ...;