JoinClause (clsColumn)
[!참고]
이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.
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
주의
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 = ""