DELETE FROM candidate join job on (candidate.jobid = job.id) join manager on (job.mid = manager.id) WHERE manager.id = 121