I guess not just CTE we can JOIN or Union any other Temp table other than itself???

Question

I guess not just CTE we can JOIN or Union any other Temp table other than itself??? As I tried to join and union other tables like employees or departments or even other Temporary tables they worked fine for me CTE too except the temporary table itself

Answer 1

Hi Mayank!

Thanks for reaching out!

Please accept my apologies for the delayed response.

Yes, you can join or union Common Table Expressions (CTEs) with other tables, including temporary tables, regular tables, or even other CTEs. There's no limitation on joining or unioning CTEs with other tables or CTEs.

Hope this helps.
Best,
Martin

I guess not just CTE we can JOIN or Union any other Temp table other than itself???

Submit an answer

related questions