You cannot create a spatial view (use 'sdetable -o create_view') to generate a UNION ALL query,
and you cannot UNION ALL layers with SDEBINARY storage, but you may be able to register such
a view on GEOMETRY or GEOGRAPHY storage with 'sdelayer -o register' or simply access it with
query layers, but only if the geometries share a single topology class and the id columns are
unique across the joined tables.
Generally speaking, if all the features share the same attributes, topology, and coordinate system,
they belong in the same table. Views can then used to efficiently extract logical subsets.
- V