Hi Reena, SELECT t1.* FROM track_points1 as t1, track_points2 as t2 WHERE st_distance(t1.the_geom,t2.the_geom) <= a;
Is that help ? Fred. On 8/29/08, S.Reena <[EMAIL PROTECTED]> wrote: > > > Hello, > > I have two tables track_points1 and track_points2 having wkb_geometry > columns. I want to make a query that can do this: > > select * from track_points1 where wkb_geometry1 in ( select wkb_geometry2 > from track_points2 where wkb_geometry1= wkb_geometry2 (+/-) a ); > > where a is any value (hexadecimal /integer)... > > [basically i want to select one geometry that is in some range of > another....] > > Can any1 help? > > Cheers, > Reena. > > > > -- > View this message in context: > http://www.nabble.com/Help-in-making-Complex-Query-tp19217346p19217346.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
