I'm developping an ArcMap Extension and I need to join an existing feature class with data from a sql query located on another DBMS.
I already set up a Workspace with an OleDbWorkspaceFactory. I'm even able to add to the document any table contained in this database. I'm now trying to add a sql query to the document the same way I do it with tables. The query can be complex and include a couple of table with inner/left joins.
I looked in the ESRI documentation and I can't find the good object to do this.