<div dir="ltr"> Hi Victor,<br /><br />> I see 2 problems with this query:<br />> 1) CTE is just a named subquery,
inyour query I see no reference to<br />> the “upd_code” CTE.<br />> Therefore it is never gets called;<br /><br
/>So,in conclusion, my misconception about CTE in general was that all CTE get called without being referenced.<br
/><br/>Thank you much for the explanation. <br />-Kong<br /><br /></div>