Update / Delete on Joined Tables

Thanks for the responses. I was initially thrown by the delete part of things but can see where you're going with this. I work with joined updates and deletes all the time, but hadn't thought of using a nested select as the where clause in CI (was hoping CI could handle it within query builder).

It's been a crazy week at work and as this is a personal project, the last thing I want to do is spend more time wrestling with code. So I'll give it go later this week (hopefully!) and let you know.