Hello all,
I'm having trouble using the "Create Database View" geoprocessing to create a view to union two polygon feature classes into one.
Due to the design, we have two feature classes represent two categories of polygons, but we need a view to display the polygon features from both feature classes, I used a very simple query to create this view for experiment:
Select Field_A1, Field_A2, Shape, ObjectID from Polygon_A
union all
Select Field_B1, Field_B2, Shape, ObjectID from Polygon_B
It gave me an error of ERROR_160195, an invalid SQL statement was used. I ran the single query for Polygon_A and B, both of them worked; Field_A1 and B1, Field A2 and B2 all have the same field type and length. It seems that this GP tool does not support "union".
Has anyone met the same problem and what would be the best solution?
Thanks!