Syntax Error in my Query Code

[PPat]

I keep getting a syntax error in my query code and I'm having trouble finding it.

DELETE *
FROM [Student_ID] As [90Hour_MainTable]
WHERE Exists (SELECT * FROM 90Hour_MainTable WHERE 90Hour_MainTable.Student_ID = Fall2011Grads.StudentID);

90Hour_MainTable and Fall2011Grads are my tables, and Student_ID and StudentID are my two fields. I'm trying to delete records from the 90Hour table that are in the Fall2011Grads table. Any tips or help is appreciated.

[June7]

Since DELETE sql deletes records from table there is no need to select a field:

DELETE FROM [90Hour_MainTable] ...

[PPat]

For what I'm trying to do, I'm trying to delete the PK so that the rest of the records in that field get deleted. And there is a syntax error with the WHERE clause:


WHERE Exists (SELECT * FROM 90Hour_MainTable WHERE 90Hour_MainTable.Student_ID = Fall2011Grads.StudentID);

?

[June7]

This phrase "rest of the records in that field get deleted" doesn't make sense to me.

DELETE doesn't delete FROM fields, it deletes FROM table: DELETE FROM tablename WHERE records match criteria;

I can't see anything wrong with the WHERE clause.

[PPat]

I mean that rest of the records associated with that PK get deleted. If that code doesn't make sense, how would you change it? (I'm sorry, I'm still learning, and thank you for your help).

[June7]

Then the PK must be in the WHERE clause.

DELETE FROM tablename WHERE Student_ID = student ID here

But that's what the EXISTS (SELECT ...) is supposed to do - retrieved a set of all Student_IDs for deletion. Might need to specify the Student_ID field instead of using * in the subquery.

Deleting records is not something I do often so sorry for the vagueness.

Review http://www.techonthenet.com/sql/delete.php