[postgis-users] performing an intersection: syntax issue

[Steven De Vriendt]

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