Join dbf with SQL Server table in GetFeatureInfo Request

[Fabio D'Ovidio]

Hi.

Is it possible to do something like this ?

I'd like to JOIN feature_id in dbf layer with information stored in SQL Server table by an SQl 
Statement.

What about ? 



  LAYER
  NAME "pug_iffi"
  TYPE POINT
  STATUS ON
  TEMPLATE  "query.html"
  DATA "puglia/pug_iffi.shp"
  TOLERANCEUNITS  PIXELS
  TOLERANCE 1000
  CLASS
    NAME "Pug_iffi"
    # TEMPLATE
    STYLE
    SYMBOL  "circlefd"
    SIZE 7
    COLOR  127 255 0  
    OUTLINECOLOR 0 0 0
   END
  END
  
  
   JOIN
   CONNECTION 
      "<OGRVRTDataSource>
        
        <SrcDataSource>ODBC:sb/@dbo</SrcDataSource>
        <SrcLayer>Query_IdFrana</SrcLayer>
        
        
      </OGRVRTDataSource>"
        
        CONNECTIONTYPE OGR
        
   TABLE "Query_IdFrana"
   TO "SELECT * FROM  dbo.Query_IdFrana  WHERE (cod_pro + id + subid = IDFRANA)"
   NAME "join"
   FROM "IDFRANA"
  END

  
  
  
  PROJECTION
		#Lat/Lon
		"init=EPSG:32633"
	END
	
	
	
END
********************************************************************************************


 Ing. Fabio D'Ovidio
 WebGIS Staff
 Planetek Italia Srl
 via Massaua, 12 - 70123 Bari - Italy
 web : http ://www.planetek.it
 e-mail : dovidio at planetek.it

********************************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060925/6828e979/attachment.htm>
-------------- next part --------------
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

   ---- File information -----------
     File:  planetek.gif
     Date:  28 Feb 2006, 16:15
     Size:  1899 bytes.
     Type:  Unknown
-------------- next part --------------
A non-text attachment was scrubbed...
Name: planetek.gif
Type: application/octet-stream
Size: 1899 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060925/6828e979/attachment.obj>