Hi
I'm new mapserver-user. I have problem to join postgis layer to postgre table. Here my map file data: DATA 'the_geom FROM (SELECT Pipeline.the_geom AS the_geom, Pipeline.gid AS gid, Pipeline.status AS status, Kondur_block.id_wk AS id_wk LEFT JOIN Kondur_block ON Pipeline.id_wk = Kondur_block.id_wk) as subquery USING UNIQUE gid USING srid=32648' And I get this message: msDrawMap(): Image handling error. Failed to draw layer named 'Pipeline'. msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR: syntax error at or near "LEFT" LINE 1: ...".status AS status, "Kondur_block".id_wk AS id_wk LEFT JOIN ... ^ Can annyone sugget what's wrong with that? For Information I use mapserver version 6.03 and postgis version 1.5.1 Thanks, Surahman
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
