Append vs Merge queries ? I do not understand the exact detailed differences!?

[MGadAllah]

Hi,
I would like to know the exact different between these two ways of combining two queries in Excel?
I tried to goggled it in my own but so far all I found were how to merge and how to append but can not figure out the exact differences so I can understand when to use append and when to use merge?
cFjeJWH.png
Thanks

[xlnitwit]

Hi,

An append query does precisely what it says - it appends all records from one query below the records from another query. You should have the same fields in each query.

A merge query is analagous to a VLOOKUP in Excel. You link one query to another using a common field.