JoinClause (clsColumn)
.gif "Hinweis") Hinweis |
|---|
Diese Funktion wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie so bald wie möglich das Ändern von Anwendungen, in denen es zurzeit verwendet wird. |
The JoinClause property of an object of ClassType clsColumn specifies the JOIN clause of the SQL query that returns a nested table for the column. This property applies to columns that belong to mining model objects of SubClassType sbclsRegular.
Data Type
String
Access
Read/write
Hinweise
This property is read/write only for nested columns (columns of SubClassType sbclsNested). For regular columns (columns of SubClassType sbclsRegular), this property is read-only and returns the JoinClause property of the column's parent object.
Examples
Creating a Nested Column
The following example creates a nested column and establishes two joins to the parent columns based on the SalesRep column and the Product column:
Set dsoNestedCol = dsoDmm.Columns.AddNew("Products", sbclsNested)
dsoNestedCol.FromClause = "Sales, SalesReps, Products"
dsoNestedCol.JoinClause = "Sales.SalesRep = SalesReps.Name AND Sales.Product = Products.Product"
dsoNestedCol.Filter = ""