Joining an external dbf table

Stephen Woodbridge woodbri at SWOODBRIDGE.COM
Fri Mar 25 08:38:27 EST 2005


Will you would use a JOIN if it were possible, but it is not for
CLASSITEM except is your are using ogr or postGIS.

You can use JOIN on queries with shapfiles but not for class selection.

-Steve W.
  http://imaptools.com

Gambin Dejan wrote:
> Hello,
>
> I have a question regarding joining an external table. I have an
> external dbf table that I want to query (and used as class expression)
> instead of item in source dbf table (the dbf table from shp). The source
> dbf table has an numeric field called ID1 that has to be joined to
> second table ID2 field and I want query to return me the NAME field from
> the second table.
>
> Can someone show me an example of map file with class expressions (I
> would like the items with different names be in different class so the
> number of classes is equal to number of different names)?
>
> What else has to be done? How to refer to it in template file?
>
> Thanks very much
>



More information about the mapserver-users mailing list