why can't I access my CTE after I used it once?

WITH MYCTE(....)
AS 
(
...
)

UPDATE ... (using my CTE)



DELETE ( using my CTE)  <---  says the object, my CTE, doesn't exist

Copy Link Twitter Facebook LinkedIn Share Edit

Save

Report