Merging tables

[Gordon Dale]

I need to merge two tables that contain Client Data e.g.
Supplier Name, Address etc as they existed as two
different entities and became out of sync. I want to take
the first table and add the missing records form the
second table. I realise there must be a 'simple' way to
achieve this and have looked at JOIN but help only seems
to cover records that have same/similar values

I would be obliged for some help

Regards

Gordon