Query: The St. Lawrence River can supply water to cities that are within 300 km. List the cities that can use water from the St. Lawrence

SELECT Ci.Name
FROM CITY Ci, River R
WHERE Distance(R.Shape,C.Shape) <= 300

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