Why Is Autonumber Not Working With Following Query

[John Kopanas]

I have the following query:

INSERT INTO summaries (entity_name, job_type, job_status)
(SELECT entity_name, "GOV", "Non-Workable" FROM tmpSummaryTable);

The only other column I have is id and it is primary key autonumber int.

Why would I get the following error?

ERROR 1062 (23000) at line 3: Duplicate entry '5' for key 1

Why is the query trying to enter a duplicate entry?

This makes no sense to me :-).

Thanks

John

-- 
John Kopanas
john@stripped

http://www.kopanas.com
http://www.cusec.net
http://www.soen.info