Temporary Tables - SQL

Hi everyone,

I see that some SQL code contains quite a number of temporary tables before performing some final calculations based on the results of the last temporary table.

What is one of the most common reasons for building a number of them?
Are we able to perform our desired query in just one single SELECT statement instead?

Would appreciate some enlightenment! :slight_smile:

Hello! I believe the reason for temporary tables is to allow you to run complex queries, so you get data in a specific way. Here is a good article on it.

1 Like