WITH ReportFolder (ReportName, Usefulness)
AS
(
SELECT R.ReportName
FROM Reports R
WHERE Usefulness = 10
UNION ALL
SELECT R.ReportName
FROM Reports R
INNER JOIN ClientsPerception CP
ON R.Usefulness >= CP.Usefulness
)
SELECT *
FROM ReportFolder
*** 0 Rows Returned ***
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment