Hi list, I'm trying to perform an intersection on 2 datasets. I'm trying to base my syntax as provided by bostongis.com http://www.bostongis.com/postgis_intersection_intersects.snippet
So I have a dataset of state boundaries and major higways in that state. I want to achieve a query where I want to select all major highways that cross a state based on the name of that state this is my syntax: select tbl_refgem_2006.the_geom, tbl_majhwys_lam72.the_geom FROM tbl_refgem_2006 INNER JOIN majhwys_lam72 ON ST_Intersection(tbl_refgem_2006.the_geom, tbl_majhwys_lam72.the_geom) WHERE tbl_refgem="Aalter"; I get the error message: ERROR: missing FROM-clause entry for table "tbl_majhwys_lam72" LINE 1: ...am72 ON ST_Intersection(tbl_refgem_2006.the_geom, tbl_majhwy... Can anyone help me out building this query ? Thanks Steven _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
