Spectrum Spatial (SSA/LIM)

 View Only
Back to discussions
Expand all | Collapse all

Spatial Manager - Create View table with UNION ALL

  • 1.  Spatial Manager - Create View table with UNION ALL

    Posted 06-28-2023 05:41

    Hi all,

    Is it possible to perform the equivalent of UNION ALL in MISQL? The "Advanced" tab within the Create a View Table menu allows writing MISQL code involving multiple tables, but I haven't been able to find any notes that explain how to perform a UNION operation of multiple tables.

    Creating a View Table

    We have several tables that we want to put in a single View Table and setup a quick query for Spectrum Spatial Analyst.

    Kind regards,



    ------------------------------
    Miquel Roy-Sunyer
    Spatial Technician
    Intelligence & Performance Service
    Kirklees Council
    ------------------------------