Just wanted to know that ' is it possible to use CTE(Common table expression) within another CTE?
With CTE1 (c1,c2) as (select c1,c2 from table1),
CTE2 (c1,c2,c3) as (select CTE1.c1, CTE1.c2, Table2.c3 from CTE1 left join TABLE2 on Table2.c1=CTE1.C1)
Select * from CTE2;
I know we can do the same using Volatile Table. But just wanted to know if upper code works?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.