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