[mapserver-users] Different data in the same layer

[Paul Austin]

What I would like to achieve is a WMS server where when the user selects 
a layer (e.g. Water) that they see Line and Polygon water features 
rendered where the lines are in the database table water_lines and the 
polygons are in the table water_polys. All the line features are 
rendered first with the polygon features rendered on top of those.

Is it possible with mapserver to define a layer which gets data from 
multiple sources? Sort of like nested layers but where the user doesn't 
see the nested layers.

An extension of this would to be also have different tables with data at 
different scales so the 1:20k data would be in water_20k_lines and the 
1:250k would be in water_250k_lines.

Throughout all of this the user just sees the Water layer.

Cheers,
Paul