I have a value that I want to do delete everything from a table that contains this value in a field. Also, each one of those that I delete has an ID that is a foreign key value in another table.

A common SQL habit is to use SELECT * on a ... If you have a table you’re constantly archiving into another table, you can avoid using INSERT/DELETE to move the data, and use SWITCH instead.

there is another table that has events stored, and linked to a calendar. For instance, there might be an event on March 31st that's linked to calendar_ID 15. <P>How do I delete all the events that ...