[postgis-users] table join in MapServer

Michael Welter mike at telecommatters.net
Mon May 7 16:32:35 PDT 2007


Nevermind, I didn't read far enough.

Michael Welter wrote:
> Without using a view, is there a way to accomplish a join between 
> several tables in the .map file?
> 
> On page 27 of the PostGIS Manual, the DATA statement reads "geom from 
> roads".  Can multiple tables be specified in the DATA statement?
> 
> The reason I'm asking is that the query optimizer is not starting from 
> the table with the geom but rather from an ancillary table.  Can query 
> optimization be overridden?
> 
> Thanks,
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
Michael Welter
Telecom Matters Corp.
Denver, Colorado US
+1.303.414.4980
mike at TelecomMatters.net
www.TelecomMatters.net



More information about the postgis-users mailing list