JoinClause (clsMiningModel)
The JoinClause property of an object of ClassType clsMiningModel specifies the JOIN clause of the SQL query that returns the cases for the mining model. This property applies only to mining models of SubClassType sbclsRelational.
Data Type
String
Access
Read/write
Remarks
This property specifies the INNER JOIN clause of the SQL pass-through query that is used to generate the training cases for the mining model. Use this property when the case information is distributed in more than one table.
Note You must separate the table and column names with the delimiters appropriate to the source database. You can use the CloseQuoteChar and OpenQuoteChar properties of the DataSource object to determine the correct delimiters.
Example
In the following code example, the JoinClause is used to join the sales_fact_1997 and customer tables:
' Assume the existence of a clsMiningModel object named dsoDMM.
dsoDMM.JoinClause = """sales_fact_1997"".""customer_id"" – " & _
"""customer"".""customer_id"""
The previous code example sets the JoinClause property to the following string:
"sales_fact_1997"."customer_id" = "customer"."customer_id".