Share via


JoinClause (clsColumn)

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

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

Remarks

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 = ""

See Also

Reference