You have a typo - change your majhwys_lam72 to tbl_majhwys_lam72 or the reverse something like below.
select tbl_refgem_2006.the_geom, tbl_majhwys_lam72.the_geom FROM tbl_refgem_2006 INNER JOIN tbl_majhwys_lam72 ON ST_Intersection(tbl_refgem_2006.the_geom, tbl_majhwys_lam72.the_geom) WHERE tbl_refgem="Aalter"; -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven De Vriendt Sent: Wednesday, March 12, 2008 4:26 PM To: [email protected] Subject: [postgis-users] performing an intersection: syntax issue 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 ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
