Help plzzz *Join without common key*

[#1]

Hello Experts,

I have got small problem I hope you guys might help me.

*I dont have field to join. Is there any way I could get what do I need?

Table1:

Key	Customers
1	Cust1
2	Cust2
3	Cust3

Table2:

Barcode	Reg_Customers
B1	vid1
B2	vid2
B3	vid3

What do I need:

AllCusts
Cust1
Cust2
Cust3
vid1
vid2
vid3

Thanks a ton in advance.

Regards,

Aamir

[pover · Accepted solution]

Hello Aamir,

Use Concatenate.

AllCusts:

Load Customers as AllCusts,

From Table1;

Concatenate (AllCusts)

Load Reg_Customers as AllCusts,

From Table2;

Don't forget to drop the tables you no longer need.

Karl

[#3]

Thanks for your help Karl

Cheers !