[mapserver-users] How to work with joins in Mapfile using Postgresql

[Venkat Rao Tammineni]

Dear Richard Duivenvoorde,

 Thanks for your great response.I am working on that , I will let you know
if I get any problem about this.

Thanks again

Regards,
Venkat.



-----Original Message-----
From: Richard Duivenvoorde [mailto:rdmailings at duif.net] 
Sent: Monday, January 05, 2009 4:05 PM
To: Venkat Rao Tammineni
Cc: mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] How to work with joins in Mapfile using
Postgresql

Hi Venkat,

isn't it possible to make a 'view' using a normal join-query?
and then use the view as your spatial tabledata?

There is something in the mapserver docs about it too:
http://mapserver.org/input/vector/postgis.html

Regards,
Richard Duivenvoorde

Venkat Rao Tammineni wrote:
> Dear All,
> 
>  
> 
>  How  can I use join in Mapfile .I am using Postgresql/postgis. I have 
> two tables .One table contains Spatial data and another table contains 
> Non-Spatial data. I want to join both two tables and I need display map. 
> How can I do this .Any can guide me.
> 
>  
> 
> I am waiting for your great response.
> 
>  
> 
> Advanced Thanks.
> 
>  
> 
> Regards
> 
> Venkat.
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users