[mapserver-users] postgis layer - postgresql table join eror

[Surahman Putra]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120813/c37df167/attachment.html>