Appending a Table: avoiding duplicates?

[naiasuszek]

I have two tables in a single database. I would like to append the information in the NewContacts (373 records) table to the AllContacts table.

I set up an append query; when I run the query it appends each record 28 times (10444 rows).

What is going on?

Thanks

 

[HiTechCoach]

Sounds like you make and a join that is not need.

Please post the SQL for your append query.