Hi,

I have areas around points (285) where I have identified the nearest point for each area. I am trying to join the areas linked to each point into single areas using Unionall.

I currently have the following SQL

SELECT * INTO [Temp2] FROM

(SELECT Plant, Unionall(GEOM([ID]))

FROM [SA1_2021_AUST_GDA2020 Drawing]

GROUP BY Plant)

It creates the Temp table with a single field called 'Column' that contains a geom with branches and coords for each 'Plant'. The field (one example) when opened in table view shows the following

<geom,area, branches, 2, coords 1333>

I have tried copying the 'Temp' and 'paste as drawing' but that process requires a Lat/long to be specified.

How do I get the query result to display as a drawing or what should I be doing with my SQL?

Regards, HG

No real need for the "INTO [Temp2]". The workflow you need is "File/Link/Drawing/This Project.. Choose Type "Table with geometry column"; Source "Name of your Query". OK should generate a linked drawing direct. Review the Linked Drawings topic.

Stuck with the table as the source but worked beautifully!

Thankyou!