sd_contains in query layer arcgis pro

CocoRulinda — Fri, 01 May 2020 14:17:44 GMT

I am quite new to this and try to create a query layer in arcgis pro with the sd_contains function. But i cannot get it right. Am i using it correctly? the syntax i am using is looks like this

SELECT A.*, B.NAME FROM table1 A LEFT JOIN table2 B ON sde.st_contains (B.geometryfield, A.gemoetryfield)=1

Can someone help me?

The (anonymized) sql query that i received from my db colleague is:

SELECT A.*, B.NAME
FROM table1 A
JOIN table2 B
ON (sdo_contains (B.geometryfield, A.geometryfield) = 'TRUE');

topic sd_contains in query layer arcgis pro in ArcGIS Pro Questions

sd_contains in query layer arcgis pro