Wednesday, June 11, 2008

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 ***

No comments: