Delete query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
My select query works fine, but when I change it to a delete query, I get
"Could not delete from specified tables." I have selected records from
EmpEdudel and I want to delete all those records from NewEmp.

Here is the SQL:
SELECT NewEmp.*
FROM EmpEdudel INNER JOIN NewEmp ON EmpEdudel.Intake_ID = NewEmp.Intake_ID;

Help!
 
Actually, solved my own problem thanks to previous questions posted here -
thanks anyway!!
 
Hello,
My select query works fine, but when I change it to a delete query, I get
"Could not delete from specified tables." I have selected records from
EmpEdudel and I want to delete all those records from NewEmp.

Here is the SQL:
SELECT NewEmp.*
FROM EmpEdudel INNER JOIN NewEmp ON EmpEdudel.Intake_ID = NewEmp.Intake_ID;

Help!
Click to expand...

Try this:

SELECT *
FROM NewEmp
WHERE Intake_ID In (SELECT Intake_ID FROM EmpEdudel);

But know that if you're setting up this as a delete query so that you
can run an append query, you could just use an Update Query.
 
Back
Top