I have an unusual problem in that I have to remove records from two tables that they have foreign keys pointing to each other.
Silly I know but that's how it's been designed and I can't drop the constraints in order to delete the records.
If I try deleting records from either table I get a foreign key constraint error message.
If there's any advice out there around removing these records without disabling the constraints I would appreciate it.
If this isn't clearly explained please let me know.