Delete query

[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!

 

[Guest]

Actually, solved my own problem thanks to previous questions posted here -
thanks anyway!!

 

[Jason Lepack]

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!

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.