|
|
|
|
|
|
by sgarland
38 days ago
|
|
|
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. |
|
|