I want to use a query to delete records. The querywould be a join of two tables that have a 1:M relationship, let's say Employee and Department.
I made this query:
DELETE tbl_Employee.EmployeeNumber, tbl_Employee.EmployeeName,
tbl_Department.DepartmentNumber, tbl_Department.DepartmentName
FROM tbl_Department INNER JOIN tbl_Employee ON
tbl_Department.DepartmentNumber = tbl_Employee.DepartmentNumber
WHERE (((tbl_Department.DepartmentNumber)=10));
On trying to run this query, Access returns the following error:
Specify the table containing the records you want to delete.
What do I need to do to specify that I want the records removed from the
Employee Table?
TIA,
Far Farley
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
<<attachment: winmail.dat>>
