Query over 2 feature classes with related fields

MarliesvL — Thu, 22 Jun 2017 06:49:45 GMT

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:

STUW
WS_DOORSTROOMOPENING_KWK

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.

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

Re: Query over 2 feature classes with related fields

MarliesvL — Thu, 22 Jun 2017 08:51:12 GMT

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.

topic Query over 2 feature classes with related fields in Geodatabase Questions

Query over 2 feature classes with related fields

Re: Query over 2 feature classes with related fields