naturalpredictionjoinmissingmappings.dmx

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

--Using NATURAL PREDICTION JOIN with missing mappings
SELECT 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, tc.MaritalStatus
			   , tc.Region 
			   FROM vCustomerProfitability tc 
			   INNER JOIN dimCustomer c ON tc.CustomerKey = c.CustomerKey')
			 AS t
ORDER BY PredictProbability([Is Car Owner],'N') DESC