Merging two tables in Access?
<p>I have two tables that have different data that I need to merge. They do have similarities such as: Order number, Name, type or product. But they have separate data as well like: Order date, and Engravings.</p>

<p>Would I do two separate Append queries in Access into a merged table? Or one Append queries? Or just keep the data separate?</p>

<p>I am new to Access and trying to find the best way to approach this.</p>