Query: For all the rivers listed in the River table, find the countries through which they pass

SELECT R.Name, C.Name
FROM COUNTRY C, RIVER R
WHERE Overlap(C.Shape,Buffer(R.Shape,300))= 1
AND R.Name = ‘St. Lawrence’

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