I can't seem to understand the workflow of editor.
Before toad I used mysql workbench and it had simple editor: need to run some SQL - create new tab for it.
Toad has this editor but it is somehow hidden in menu (only ctrl+N to create new editor?). And I don't think it is the same as workbench's tab - every editor has its own session to the database. I don't understand this one session per editor thing. If I need to try out some SQLs which deals with temporary tables (create and select) I have to delete code in the same editor and paste new code?
Let's say I have two SQLs with temporary table creation and one which joins those temporary tables (3 different SQLs). In workbench I would make 3 new tabs, paste the code and run it. No matter from which tab I would run the code both temporary tables would be visible to the SQL which joins both temporary tables. But with Toad I'm struggling: Every editor has its own session and temporary tables are session based. So if I use 3 editors to run those 3 SQLs the SQL which joins two temporary tables will error out because it will not see those two created temporary tables.
Right now I'm doing it like this: Open new editor (ctrl+N), Paste SQL for first temp table - run it, Delete everything from editor, Paste SQL for second table - run it, Delete everything from editor, Paste SQL for joining temporary tables - run it.