upvote
It would, but it forces the requirement of DISTINCT. With the original, if there were declared PKs (pokemon_name is fine for the main table, with a composite for others), the semi-join (EXISTS) would eliminate the need for DISTINCT entirely.

I think. Doing this in my head, but you could verify it trivially with SQLite or any other RDBMS.

reply
deleted
reply