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:
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.
In SQL developer I have the following working query:
FROM STUW s
JOIN WS_DOORSTROOMOPENING_KWK d ON (s.LOKAALID = d.WS_STUWID)
WHERE s.HOOGTECONSTRUCTIE < d.WS_HOODOOSTRHOO
But this does not work in ArcGis.