How to combine two tables in their entirety (some columns are the same, some are not)

[jscivias]

Hello, if I am trying to combine the first two tables and create a new table (third), but I am not having much luck with either append or merge queries:

when i try append query, the new table does contain all seven columns but not all rows (from both tables) show up. if i try merge query, i just run into problems.. 

any help appreciated, thanks a lot. 

[jbwtp · Accepted solution]

Hi @jscivias,

I am quite surprised that Append does not show up all rows from both tables, it doe snot do any filtering or duplicate removal by default. It should be some other step which does it.

For Merge (to achive the bottom table form the top two: use JoinKind.FullOuter rather than JoinKind.LeftOuter which is used by default.

Hope this helps.

Cheers,

John