AnsweredAssumed Answered

How to perform join and query with composite keys

Question asked by taungesriaustralia-com-au-esridist Employee on May 20, 2020
Latest reply on May 21, 2020 by taungesriaustralia-com-au-esridist

Hi Guys,


I have basin feature class, platform table in my geodatabase.

They have composite keys relationships, (meaning two keys as primary keys)


Example sql query statement I want to perform in sdk is  select p.id1, p.basinname, p.segmentname from platform p LEFT JOIN basin b ON p.id1 = b.id1 and p.id2 = b.id2 where p.category = 'thirdparty'


Refer to that statement id1, id2 are the composite keys.


How can I do this in arcgis pro sdk?


I tried and referred to sdk doco geodatabase api => ProConcepts Geodatabase · Esri/arcgis-pro-sdk Wiki · GitHub 

And I can't figure it out how to manage with arcgis pro sdk?