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:rdmaili...@duif.net] Sent: Monday, January 05, 2009 4:05 PM To: Venkat Rao Tammineni Cc: mapserver-users@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@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users