Join or Concatenate

[Black_Hole]

Hello all,

I would like to join two tables using a common key (ID).

#1 : The source of the first table is a connection to a database.

#2 : The source of the second table is an excel file.

I tried to join these tables using a left join. 

The IDs which are in the excel file, but not in my database are not recuperated in the result of joined table.

And that's my problem! In my result, I would like to have the result of the joined table and also the IDs which are not in the database (and vice versa, the IDs which are not in my excel file but not in my DB).

Please could you advise which join function I need to use in order to find the result describe above.

Thank you in advance for your help.

[StarinieriG · Accepted solution]

Hi,

so, if don't want to lost rows, try to use simply "Join"

[Black_Hole]

Hi @StarinieriG ,

Great, I try it and I find the expected result.

Many thanks for your quick and effective reply!