What syntax is used when creating a table or feature layer based on a query?
Answer
Use SQL, the syntax of the native underlying database. Also keep in mind that these queries do not support all of the functions and statements available in the underlying database. The IQueryDef interface is used to set the query.