[postgis-users] table join in MapServer

[Michael Welter]

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,