这是返回所需结果的查询：
SELECt LoyaltyPointTable.LoyaltyType, CASE WHEN LoyaltyPointTable.LoyaltyPointsId=4 THEN (SELECT COUNT(amount) FROM RedeemPointsTable where CustomerId=1) ELSE COUNT(CustomerTable.CustomerId) END as UserActions, CASE WHEN LoyaltyPointTable.LoyaltyPointsId=4 THEN (SELECt SUM(amount) FROM RedeemPointsTable where CustomerId=1)*Points ELSE SUM(LoyaltyPointTable.Points) END as TotalPointsFROM LoyaltyPointTable JOIN LoyaltyDetailsTable ON LoyaltyPointTable.LoyaltyPointsId = LoyaltyDetailsTable.LoyaltyPointsIdJOIN CustomerTable ON CustomerTable.CustomerId = LoyaltyDetailsTable.CustomerId WHERe CustomerTable.CustomerId = 1GROUP BY LoyaltyDetailsTable.CustomerId ,LoyaltyPointTable.LoyaltyType
你可以在这里检查
