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.*. Can you provide an example of your layer? Thanks, Regina
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Giuseppe Molinario Sent: Wednesday, June 27, 2007 4:44 AM To: PostGIS Users Discussion Subject: [postgis-users] Joined, queried or table views in Mapserver Mapfile. Hi everyone, Wondering if this question is not better suited for a Mapserver forum, I'll post it anyway in case someone has an easy solution... 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? Thanks, Giuseppe ----------------------------------------- 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.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
