Heterogenous queries

You can use heterogenous queries to join the data from SQL Server to the data in the linked server.

Example of a heterogenous query

The following query returns the name and path of the corresponding elements from whose name is stored in a local SQL table, dbo.AttributeList.

SELECT afelement.Name, afelement.path
FROM dbo.AttributeList INNER REMOTE JOIN
LINKED_SERVER.Master.Element.ElementHierarchy AS afelement
ON afelement.Name = dbo.AttributeList.AF_ElementName