retrieve one column after matching multiple column between two tables

[Anonymous]

I have tow table-a (ex : Column1- 10)  Table-b (Column 1-5(same value as columnA)  and two additional colum (Col X, ColY)

I need add Col- X after matching Table-a(column1-5) and  Table(column1-5). Note:  both tablea, table b  columns (1-5)has Many to many releation ship.

Table-a     1 2 3 4 5 A A A A B

                  1 2 3 4 5 A A A B B

Table -b       1 2 3 4 5 X1 Y1

                  1 2 3 4 5 X2 Y2

What is the best method to retirve Col X 1, X2, Y1, Y2 after matching 1-5 column of Table-a and Table-B

[pranit828]

HI @Anonymous 

You can concatenage these 5 column in both table and create a relationship between these two.

Then arriving at the logic to get X1,Y1, X2 and Y2 will become easier.

[Anonymous]

Thanks for reply.  Concatnate only work with two strings and still not sure even after i merge column value (any other method) how this will work. Note: My table A- Update on real basis.  Table -B is static., so when new row added into table-A, i need to fetch corresponding value from Table B

[Anonymous · Accepted solution]

working fine. Concatnate matching column using query editor and used lookupfunction.