场景描述:
需要删除上海市和广州市城市代理的名下的医生关系
需要用到的表
agent_doctors(医生代理关系表,多对多)
agents(代理表)
agent_cities(代理所属城市表,多对多)
cities(城市表)
DELETE agent_doctors FROM agent_doctors
LEFT JOIN agents ON agents.id = agent_doctors.agent_id
LEFT JOIN agent_cities ON agent_cities.agent_id = agents.id
LEFT JOIN cities ON cities.id = agent_cities.city_id
where cities.name in ('广州市','上海市')