naturalpredictionjoin.dmx

来自「< SQL Server2005程序设计>」· DMX 代码 · 共 14 行

--Using NATURAL PREDICTION JOIN
SELECT TOP 250 t.FirstName, t.LastName, t.Phone, 
	   PredictProbability([Is Car Owner],'N') AS ProbNotCarOwner
FROM   CarOwner_DT 
NATURAL PREDICTION JOIN 
	OPENQUERY([Adventure Works DW],
			  'SELECT c.FirstName, c.LastName, tc.Phone
                      , tc.Gender, tc.IncomeGroup AS [Income Group]
                      , tc.MaritalStatus AS [Marital Status]
                      , tc.Region 
			   FROM   vCustomerProfitability tc INNER JOIN dimCustomer c 
			   ON     tc.CustomerKey = c.CustomerKey') 
	AS t
ORDER BY PredictProbability([Is Car Owner],'N') DESC