<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=188480713-27062007><FONT face=Arial
color=#0000ff size=2>Not sure I understand your question. I've never had
problems displaying data from joined tables in either right or left table via
Mapserver as long as I alias the field names in cases where the names could be
found in both tables or avoid doing something like table.*.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=188480713-27062007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=188480713-27062007><FONT face=Arial
color=#0000ff size=2>Can you provide an example of your
layer?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=188480713-27062007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=188480713-27062007><FONT face=Arial
color=#0000ff size=2>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=188480713-27062007><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=188480713-27062007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=188480713-27062007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Giuseppe Molinario<BR><B>Sent:</B> Wednesday, June 27, 2007 4:44
AM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> [postgis-users]
Joined, queried or table views in Mapserver Mapfile.<BR></FONT><BR></DIV>
<DIV></DIV>Hi everyone, <BR><BR>Wondering if this question is not better suited
for a Mapserver forum, I'll post it anyway in case someone has an easy
solution... <BR><BR>My problem is this: I am usind the following layer in a
Mapserver based application. The DATA connection works, objects are visible on
the map in their correct place and symbology, however the query of the postgis
table works only if I name the columns of the LEFT table in the RESULT FIELDS.
How do i get the thing to query also my Columns from the joined table? Why on
earth would i have the same problem usind the DATA connected to a table view?
<BR><BR>Thanks, <BR><BR>Giuseppe <BR></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>