All pastes #805881 Raw Edit

JuJuBe

public text v1 · immutable
·published 2007-12-04 19:20 UTC
rendered paste body
I have a select statement as follows...
 
SELECT ... from user,class,category,assignment,grade
WHERE grade.assignment_id=assignment.assignment_id
AND assignment.category_id=category.category_id
AND category.class_id=class.class_id
AND class.teacher_id=user.user_id
AND user.user_id=87

Can I change this to a delete statement simply by changing SELECT to DELETE?  This select
displays the appropriate information I wish to delete from a table.