在一条查询语句中创建临时表,并对临时表进行进一步查询
WITH PPC AS (
SELECTA.*
FROM(
SELECT
ROW_NUMBER() OVER (PARTITION BY PPCMemberID ORDER BY CreatedOn DESC) AS RN,
PPCMemberID,PPC,DailyBudget,CreatedOn
FROM
CSK_Store_PPCBudgetHistory
) A
WHERE RN = 1
),
PPCM AS (SELECT PPCMemberID,RetailerID FROM CSK_Store_PPCMember),
RP AS (SELECT RetailerID,ProductID,PurchaseURL FROM CSK_Store_RetailerProduct WHERE ProductID = 1337534)
SELECT
RP.*,
PPCM.PPCMemberID,
PPC.PPC,PPC.DailyBudget
FROM
RP LEFT JOIN
PPCM ON RP.RetailerID = PPCM.RetailerID LEFT JOIN
PPC ON PPC.PPCMemberID = PPCM.PPCMemberID