您没有指定RDBMS,所以在MySQL中
DELETe teammembers FROM teammembersJOIN teams on teammembers.teamId = teams.teamIdWHERe teams.eventId = 1

您没有指定RDBMS,所以在MySQL中
DELETe teammembers FROM teammembersJOIN teams on teammembers.teamId = teams.teamIdWHERe teams.eventId = 1