Forum Discussion

shaebert's avatar
shaebert
Helper III
2 years ago
Solved

Merge Queries Help

Hello, I am looking for help in merging two tables. I don't know what join will achieve the following:       
Need Help
  • CoreyP's avatar
    CoreyP
    2 years ago

    You need an additional element to differenciate why the values of C are different. Otherwise both C values from table one will join to the C value of table two.

parry2k's avatar
parry2k
Super User
2 years ago

shaebert add the index column in both the tables, and then do the merge on Column1 and Index and that will do it.

 

  • shaebert's avatar
    shaebert
    Helper III
    2 years ago

    The reason this doesn't work, is that the D and E won't match now.