[postgis-users] table join in MapServer

[Paul Ramsey]

DATA "the_geom from (select a.the_geom, a.b, b.uid, b.b from a, b where 
a.i = b.i) as rslt using srid = 4326 using unique = uid"

http://postgis.refractions.net/docs/ch04.html#id3021503

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


-- 

   Paul Ramsey
   Refractions Research
   http://www.refractions.net
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632