One to many joins

Erich Schroeder erich at museum.state.il.us
Tue Feb 22 08:16:33 EST 2000


Hi,
  I have a 3.0007 mapfile set up with point layer of zipcode centroids,
joined to a dbf file with museums. In some cases there are several museums
in the same zip code, and I want a query to list all the records that
match with the zip. Right now it only brings up one record. My layer
section looks like:

LAYER
  NAME zips
  TYPE POINT
  STATUS ON
  DATA zips
  CLASS
    SYMBOL 3
    COLOR 0 0 255
    NAME "IAM Museums"
    EXPRESSION ([MUSEUM] > 0)
  END # class
  QUERYITEM "ZIPCODE"
  QUERY
   EXPRESSION ([MUSEUM] > 0)
   template museum_detail.html
   JOIN
     template museum_detail.html
     name "museumdetail"
     type multiple
     table "museums.dbf"
     from "ZIPCODE"
     to "ZIP"
   END # join
 END # query
END

What have I misunderstood?

Erich

---------------------------------------------------------------------
Erich Schroeder                    Phone: (217)785-0033
Curator, Information Technologies  FAX:   (217)785-2857
Illinois State Museum GIS Lab      Internet: erich at museum.state.il.us
http://www.museum.state.il.us/ismdepts/anthro/staff/erich/erich.html
---------------------------------------------------------------------




More information about the mapserver-users mailing list