Is there a more efficient way to delete stuff than having a million DELETE statements inside of a million other SELECT statements? I see that it works, but the problem is when it comes to a place where there is nothing to delete (but something needs to be later down the path) it just stops the whole deleting process. I'll try to explain it as best I can. I have a database for schools. I have three tables for schools, teachers, and assignments. The assignments relate the the teachers table, and the teachers table relates to the schools table. The objective is to delete a school (and everything that corresponds with that school, i.e. the teacher) from the admin panel. Currently, my deleting process looks like this - [!--coloro:#990000--][span style=\"color:#990000\"][!--/coloro--][b] SELECT statement to select the school information while loop for the rows as results { SELECT statement to select all teacher information based on the school's ID while loop for the rows as results { DELETE statement to delete the assignments based on the teacher's ID } DELETE statement to delete all the teachers in that school } DELETE statement to delete the school itself[/b][!--colorc--][/span][!--/colorc--] The problem is if I try to delete a school that has no teachers in it, it'll stop at the DELETE assignments (because without any teachers, there can be no assignments) and won't continue on. How would I enable it to continue on even if there are no teachers? Thanks for the help!