AnsweredAssumed Answered

Query over 2 feature classes with related fields

Question asked by gismiep on Jun 21, 2017
Latest reply on Jun 22, 2017 by gismiep

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.

 

Managing Data

Outcomes