Query JOIN table between SHP and MySQL

[Frank Warmerdam]

Bayu Kurniawan R wrote:
> How to join between ESRI Shapefile data with MySQL data
> I'm try with http://mapserver.gis.umn.edu/docs/reference/mapfile/join
> 
>  JOIN
>         NAME "DEMO"
>         CONNECTION "MYSQL:DEMO,host=localhost,port=3306,user=root,password="
>         CONNECTIONTYPE ogr
>         TABLE "Gabungan"
>         FROM "Kecamatan"
>         TO "kecamatan"
>         TYPE ONE-TO-ONE
>     END
> 
> but my query is no result

Bayu,

It was my understanding that the JOIN declaration in the mapfile only works
for dbf files, not ogr datasources though I could be wrong.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org