hi I want to do a simple join of 3 tables who dont share any common field they just have the same number of rows. I have table 1=abc table 2 = 123 I want a table that would be table 3=a,1b,2c,3 Im tagled with all the left/first inner/outer joins... I just want the two "stitched" together. thnxC

Hi chronis69,Assuming that they both are in the sorting you need.Add an index colum to each table then make merge based on index of both tables.

Forum Discussion

Microsoft Employee

6 years ago

Solved

I want to do a simple join of 3 tables who dont share any common field they just have the same number of rows. I have

table 1=

table 2 =

I want a table that would be

table 3=

a,1

b,2

c,3

Im tagled with all the left/first inner/outer joins... I just want the two "stitched" together.

thnx