sd_contains in query layer arcgis pro

[CocoRulinda]

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');