TED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2007 10:42 PM
Subject: Re: Why Is Autonumber Not Working With Following Query
Wow, I am a little tired... this is the query causing me the problem...
INSERT INTO jobs
(SELECT * FROM tmpJobs WHERE NOT EXISTS
(SELECT * FROM jobs
Wow, I am a little tired... this is the query causing me the problem...
INSERT INTO jobs
(SELECT * FROM tmpJobs WHERE NOT EXISTS
(SELECT * FROM jobs WHERE jobs.customer_number <=>
tmpJobs.customer_number and jobs.job_number <=> tmpJobs.job_number));
Why is the id not creating distinct #s?
On 4/
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: Du
