-- *** before: ***
-- tables were listed with commas, and the join condition
-- was mixed with the filter in the same WHERE clause
SELECT city.Name, country.Name
FROM city, country
WHERE city.CountryCode = country.Code
AND country.Continent = 'Europe'
-- *** in version 92: ***
-- the join lives in its own clause, the filter stays in WHERE
SELECT city.Name, country.Name
FROM city
INNER JOIN country ON city.CountryCode = country.Code
WHERE country.Continent = 'Europe'
-- Support: all seven dialects. Access needs the explicit form and
-- wraps every join in parentheses when three or more tables meet;
-- CROSS JOIN is missing there as well.