The query below works correctly when run against MS SQL, but fails when run against Denodo Virtual DataPort Administration Tool. The error that is returned in Denodo states “View ‘bom’ not found.” As you can see in the query, bom is defined as the result from the CTE, so I don’t understand why it is not being found. I assume that Denodo handles CTEs differently from MS SQL, and that is what’s causing the problem, but I don’t know how to re-write the query for Denodo VQL.