ANSI joins are fully supported for remote data access. If a query cannot be translated, CIS will compensate functionally. The following rules apply to ANSI joins with remote data:
