I'm struggling with a query relating to a drawing with lots of touching polygons.
I would simply like to return the number of neighbours touching each individual polygon.
I've got this query, but that selects polygons that touch others, but can't work out how to return a count column.
SELECT A.[ID] INTO test FROM [Drawing] AS [A], [Drawing] AS [B]
WHERE Touches( A.[ID], B.[ID]) AND A.[ID] <> B.[ID]
GROUP BY A.[ID]