Make sure the joined fields are of the same type asnd size. Angelo
----- Original Message ----- From: Richard Rogers Beasimer [mailto:[EMAIL PROTECTED] Sent: 6/28/2005 7:51:35 AM To: [email protected] Subject: RE: [AccessDevelopers] Delete Statement SQL isn't liking the JOIN part of the statement. Errors out at "INNER". -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Douglas Sent: Monday, June 27, 2005 16:35 To: [email protected] Subject: RE: [AccessDevelopers] Delete Statement Importance: Low DELETE FROM tblWorking INNER JOIN tblBudgetHistory ON tblWorking.sort = tblBudgetHistory.sort and tblWorking.newpno = tblBudgetHistory.newpno ND tblWorking.perioddate = tblBudgetHistory.perioddate You haven't joined the other table in the below query. hope that helps, Eric -------------------------------------------------------------------------------- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Rogers Beasimer Sent: Monday, June 27, 2005 2:33 PM To: [email protected]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [AccessDevelopers] Delete Statement I about ready to give up on this. What's wrong with my delete statement? DELETE FROM tblWorking WHERE tblWorking.sort = tblBudgetHistory.sort and tblWorking.newpno = tblBudgetHistory.newpno AND tblWorking.perioddate = tblBudgetHistory.perioddate The idea is to remove every entry in tblWorking that has a corresponding entry in tblBudgetHistory. RRB NOTICE: This e-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. The contents of this e-mail are confidential. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Please virus check all attachments to prevent widespread contamination and corruption of files and operating systems! Please zip all files prior to uploading to Files section. Please zip all files prior to uploading to Files section. NOTICE: This e-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. The contents of this e-mail are confidential. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Please virus check all attachments to prevent widespread contamination and corruption of files and operating systems! Please zip all files prior to uploading to Files section. -------------------------------------------------------------------------------- YAHOO! GROUPS LINKS ยท Visit your group " [http://groups.yahoo.com/group/AccessDevelopers] AccessDevelopers " on the web. To unsubscribe from this group, send an email to: [mailto:[EMAIL PROTECTED]@yahoogroups.com Your use of Yahoo! Groups is subject to the [http://docs.yahoo.com/info/terms/]Yahoo! Terms of Service . --------------------------------------------------------------------------------
