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

[Richard Duivenvoorde]

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