two tables join

[#1]

Hi, two tables to join with resident

[Joaquin_Lazaro]

Hi;

Look at this sample JOIN sample, here you have all the join function possibilities

Regards

Joaquín

[#3]

hello JoaquinLR

i am trying all the possibilites

but couldnot make it happen

[Joaquin_Lazaro]

Hellos

BudgetTemp:

Left Join (KPIFin)

Load

*,

Mid(BudgetPeriod, 3,2) as Period

Resident Budget;

Drop table Budget;

I think you should write the sentence in red.

Regards

Joaquín

[Anonymous]

It seems, both the table have same column structure...

For auto concatenation both the table should have same column name else you need to force the concatenation.

What you want to do ?  Join or concatenation?