Query JOIN table between SHP and MySQL

[Bayu Kurniawan R]

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 Kurniawan R
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20071116/bc029d09/attachment.htm>