[UMN_MAPSERVER-USERS] Joining sql server table to shp files

[Budi Hermansyah]

i try to join shp file with table in sql server to get data aggregate from
sql server. How ? please correcting this script. Thks.
mapfile :
         LAYER
            NAME "kabupaten1"
                DATA "Kab_Point_point.shp"
          JOIN
            NAME "test"
            CONNECTIONTYPE ogr
            CONNECTION    "<OGRVRTDataSource>
                           <OGRVRTLayer name='POW'>
                           <SrcDataSource>ODBC:id/[EMAIL 
PROTECTED]</SrcDataSource>

                           <SrcSQL>select * from vrekonstruksi</SrcSQL>
        
#<SrcLayer>vrekonstruksi</SrcLayer> 
                           #<GeometryType>wkbPoint</GeometryType> 
                           #<LayerSRS>WGS84</LayerSRS>
                           #<GeometryField encoding='PointFromColumns'
x='Longitude' y='Latitude'/> 
                           </OGRVRTLayer>
                           </OGRVRTDataSource>"
            TABLE "vrekonstruksi"
            FROM "KODE_KAB"
            TO "KODELOKASI"
            TYPE ONE-TO-ONE
           END
                
                STATUS DEFAULT
                TYPE POINT
                LABELITEM 'KODE_KAB'
                CLASS
                   SYMBOL 7
                   SIZE 5
                   COLOR 255 0 0                                
                   LABEL 
                      #FONT arial
                          TYPE BITMAP
                          SIZE LARGE
                          POSITION AUTO
                          PARTIALS FALSE
                          OUTLINECOLOR 255 255 255
                          COLOR 0 0 255
                   END
                   TEMPLATE "QueryViewMap.html"
                   #COLOR 255 200 100
                   OUTLINECOLOR 0 0 0 
                END             
END