Data Mining - Professional SQL Server Analysis Services 2005 with MDX - page 753

t.[FirstName],
t.[LastName],
t.[EmailAddress],
[v Target Mail].[Bike Buyer] as [Predicted Value]

From

[v Target Mail]
PREDICTION JOIN
OPENQUERY ([Adventure Works DW],
'SELECT
[CustomerKey],
[FirstName],
[LastName],
[EmailAddress],
[MaritalStatus],
[Gender],
[YearlyIncome],
[TotalChildren],
[NumberChildrenAtHome],
[EnglishEducation],
[EnglishOccupation],
[HouseOwnerFlag],
[NumberCarsOwned],
[CommuteDistance],
[Region],
[Age],
[BikeBuyer]
FROM
[dbo].[vTargetMail]
') AS t

ON

[v Target Mail].[Marital Status] =
t.[MaritalStatus] AND
[v Target Mail].[Gender] = t.[Gender] AND
[v Target Mail].[Yearly Income] =
t.[YearlyIncome] AND
[v Target Mail].[Total Children] =
t.[TotalChildren] AND
[v Target Mail].[Number Children At Home] =
t.[NumberChildrenAtHome] AND