Great comments everyone.

This code introduced me to the WITH statement. perhaps I had seen it before, but I apparently put it out of my mind.

From what I've read, this common table expression acts like a view inside a query.

I've never been able to get this straight, but since it acts like a view, is that why deleting items from the cteDV will delete items from the base temp table, or is this something specific to the WITH statement? :unsure:

I got my information from the following site: http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:releases:2.5:statement_with_option