<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>question about joining</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Hello,</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">I have not used the Join shapefile to database function in mapserver before. I just have a couple questio</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">ns</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Symbol">·<FONT FACE="Courier New"> </FONT></FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">The description explains that</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">“It is important to understand that JOINs are</FONT></SPAN><SPAN LANG="en-us"><I> <FONT FACE="Calibri">ONLY</FONT></I></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"> available once a query has been processed. You cannot use joins to affect the look of a map.”</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"> </FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">Does that mean that we can only use the joins for templates. If possible, I would like to</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">label using a field in a joined table</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Symbol">·<FONT FACE="Courier New"> </FONT></FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">Is the following formatted correctly</FONT></SPAN><SPAN LANG="en-us"> </SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"> <FONT FACE="Calibri">#CLASSITEM 'PARC_CODE'</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"> <FONT FACE="Calibri">JOIN #TEST</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"> <FONT FACE="Calibri">NAME "MyJoin"</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"> <FONT FACE="Calibri">TABLE "LyonCounty/Parcels/test.dbf"</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"> #location of the dbf file</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"> <FONT FACE="Calibri">FROM "P</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">ARCEL_ID</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">"</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"> #shapefile field</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"> <FONT FACE="Calibri">TO "P</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">IN</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">"</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"> #dbf field</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"> <FONT FACE="Calibri">TYPE ONE-TO-ONE</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"> <FONT FACE="Calibri">END #JOIN</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"> <FONT FACE="Calibri">…</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"> <FONT FACE="Calibri">TEXT (</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">“</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">Name</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">”</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"> * [MyJoin_MYNAME]) #label</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"></FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">using the joined table</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Thanks</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">Mark Volz</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">GIS Specialist</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Lyon County, MN</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
</BODY>
</HTML>