Query over 2 feature classes with related fields

757
1
06-21-2017 11:49 PM
MarliesvL
New Contributor

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:

  1. STUW
  2. WS_DOORSTROOMOPENING_KWK

With a relate on fields:

  1. LOKAALID in STUW
  2. 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.

https://community.esri.com/community/gis/managing-data?sr=search&searchId=15e0cf4a-e3a9-4043-a174-f2...

0 Kudos
1 Reply
MarliesvL
New Contributor

In SQL developer I have the following working query:

SELECT *
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.