I would like to make a query in ArcGis to compare two heights in 2 different Feature classes in 1 Oracle-scheme. There is a related field in both feature classes, but no relationship class.
The schemes name in Oracle: VOORPORTAAL
The 2 Feature Classes:
With a relate on fields:
- LOKAALID in STUW
- WS_STUWID in WS_DOORSTROOMOPENING_KWK
I would like as result the records where HOOGTECONSTRUCTIE (from STUW) is less than the related WS_HOODOOSTRHOO (from WS_DOORSTROOMOPENING_KWK).
I would like to run this query in Datareviewer to check our data. Manually actions are not allowed.
Thank you for your reaction.