[postgis-users] performing an intersection: syntax issue

[Obe, Regina]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Steven De Vriendt
Sent: Wednesday, March 12, 2008 4:26 PM
To: postgis-users at postgis.refractions.net
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
postgis-users at postgis.refractions.net
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.