Query: Find the names of all countries which are neighbors of the United States (USA) in the Country table

SELECT C1.Name AS "Neighbors of USA"
FROM COUNTRY C1, COUNTRY C2
WHERE Touch(C1.Shape,C2.Shape) = 1
AND C2.Name='USA'

Última modificación: Friday, 18 de November de 2005, 17:10