Use complicated joins

You can only use simple joins between SQL Server tables and the AVEVA Historian OLE DB extension tables. Joins typically require use of the INNER REMOTE JOIN syntax.

For an example of the INNER REMOTE JOIN syntax, see -old-Using an INNER REMOTE JOIN.